# SumIf with more than on criteria

Posted by Rudi Holans on February 08, 2002 2:48 PM

Is it possible to use SumIf when then there is more than one criteria?
For example: sum range C1:C10 if A1="A" and B1="B".
Or need I a totally different function?

Rudi

Posted by Aladin Akyurek on February 08, 2002 2:56 PM

NO. Only when you have a between condtion like greater than 10 and less then 50.

In other cases of summing with multiple conditions, you can use an array or SUMPRODUCT formula as in:

=SUMPRODUCT((A1:A10="A")*(B1:B10="B"),(C1:C10))

=====

Posted by Brian on February 08, 2002 4:41 PM

I have a similar problem using two criteria. Only I'm searching for text. i.e "employee name" and "vacation" then summing if it meets the two criteria. I've tried your formula but get an #value error message. Can you help?

Brian

Posted by Aladin Akyurek on February 09, 2002 12:49 AM

Multiconditional Sum

Brian --

Would you post the formula that you tried, along with what kind of values you have in the ranges of interest and criteria?

=========

Posted by Brian on February 09, 2002 12:41 PM

Aladin - I figured it out! Thanks!!!!

Posted by rudi holans on February 10, 2002 1:49 AM

Re: Aladin - I figured it out! Thanks!!!!

How does your formula look like Brian?

Rudi

Posted by Brian on February 10, 2002 8:10 AM

Rudy

=SUM(IF(\$G\$1:\$G\$99="employee name",IF(\$I\$1:\$I\$99="vac",(\$H\$1:\$H\$99))))+SUM(IF(\$B\$1:\$B\$99="employee name",IF(\$D\$1:\$D\$99="vac",(\$C\$1:\$C\$99))))