To sum for "done"...

=SUMIF(A1:A10,"done",B1:B10)

--
Biff
Microsoft Excel MVP


"DogmaDot" wrote in message
...
I need to find the total from Col B if Col A is one of the 3 possibilities

A B
DONE 0
DONE 60
OBS 40
POST 55
DONE 40
DONE 0
DONE 47
POST 55

DONE RESULT
OBS RESULT
POST RESULT