Hi Paul,

you could replace the criteria with a range if you used SUMPRODUCT instead
of SUM.

=SUMPRODUCT(SUMIF(A:A,D2:D4,B:B))




"Dazed&Confused" wrote in message
...
Hi Jacob,

A quick question
Is it possible to replace the criteria inside the curley brackets with
cell
references (I'm getting an error message)?

Thanks

Paul

"Jacob Skaria" wrote:

Try the below for total for "Post"
=SUMIF(A:A,"Post",B:B)

'Try the below for total of all three
=SUM(SUMIF(A:A,{"Post","OBS","Done"},B:B))


--
Jacob (MVP - Excel)


"DogmaDot" wrote:

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