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
