close
I'm still getting the #NUM. I was wondering if formatting could have
anything to do with it. I know when I'm using lookup formulas the format is
one area I usually look at but I can't seem to find anything with this.
Thanks for your assistance.
--
Constancequot;Petequot; wrote:
gt; I think your original formula should be:
gt;
gt; =sum(IF(((name=a2)*(dept=b2)*(earn_code=c2)),hours ,0))
gt;
gt; type this in then press CTRL SHIFT and ENTER at the same time - the
gt; curly brackets will be added automatically.
gt;
gt; Pete
gt;
gt;
全站熱搜
留言列表
