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