Sum in a column if there are 3 conditions in another column

[DogmaDot]

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

 

[Jacob Skaria]

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))

 

[T. Valko]

To sum for "done"...

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

 

[Dazed&Confused]

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

 

[Steve Dunn]

Hi Paul,

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

=SUMPRODUCT(SUMIF(A:A,D24,B:B))

 

[Dazed&Confused]

Hi Steve,

The trouble with SUMPRODUCT is that it eats memory and slows this ancient PC
to a crawl.

Oh well

Paul