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:


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".


OzGrid Business Applications

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

See also: