Hi

From your description SUMIF should work (if you have one criteria) or
SUMPRODUCT if you have more than one criteria at a time ....

if you'ld like to type out 5 lines of your data (the relevant bits) and copy
& paste in the SUMIF function you tried to use, we might be able to assist.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"rfhorn" wrote in message
...
I have worksheet listing employees and their classification of DL(Direct
Labor) or IDL(Indirect Labor) and how much they earn. I am trying to sum
the
DL and IDL. I tried to use the sumif function but it did not work. What
function should I be using?