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

  • Thread starter Thread starter DogmaDot
  • Start date Start date
D

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
 
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))
 
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
 
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))
 
Hi Steve,

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

Oh well

Paul
 
Back
Top