MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sumif with two conditions


Posted by Dax on April 17, 2001 4:36 AM

Is it possible to apply a sumif based on condition A in column A being true and condition B in column B being true? Values are in column C.


Posted by Dave Hawley on April 17, 2001 5:07 AM


Hi Dax

Personally I would use the DSUM for this (see Excel help) but you could use an array formula like below:

=SUM(IF(A1:A10="Rat",IF(B1:B10="Cat",C1:C10)))


This will sum C1:C10 if the same rows in B has Cat and A has Rat. As with ALL arrays you MUST enter tis by pushing Ctrl+Shift+Enter.


I have some more important rules on arrays on my website under "Array Formulas".


Dave


OzGrid Business Applications

Posted by Aladin Akyurek on April 17, 2001 6:31 AM

See also:

12726.html

Aladin