Array formula
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.
--
Constance
"Pete" wrote:
I think your original formula should be:
=sum(IF(((name=a2)*(dept=b2)*(earn_code=c2)),hours ,0))
type this in then press CTRL SHIFT and ENTER at the same time - the
curly brackets will be added automatically.
Pete
|