SUMIFS with 3 criteria instead of just 2

H

Hopper

I am trying to get SUMIFS function to SUM a range of cells only if three
criteria are met. I have tried the SUMIFS function for two of the criteria
and then added SUMIF to the end for the 3rd criteria, but it always defaults
to the SUMIF function even though the first 2 criteria are not met.

Example:

=SUMIFS(C32:C33,E32:E33,"4",G32:G33,"6")+SUMIF(I32:I33,"<96",C32:C33)

It is adding cells together even when 4 & 6 criteria are not met.

Anyone have any ideas!

Thank you!
 
P

Peo Sjoblom

=SUMPRODUCT(--(E32:E33=4),--(G32:G33=6),--(I32:I33<96,C32:C33)

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum if one or another criteria 5
SUMIF based on several criteria. 6
Using SUMIFS with date range 4
SUMIF with multiple criteria 5
Cell Color Recognition and Summing of Data Within a Specified Colo 1
sum of info in a range based on dates 4
How to use Sumifs with vertically and horizontally criterias 1
How to use Sumifs with vertically and horizontally criterias 3

Top