=sumif(*)

Posted by Rob on July 17, 2001 10:42 AM

In this formula, is it possible to specify more than one range of search criteria? If so, how?

Thanks,
Rob

Posted by Aladin Akyurek on July 17, 2001 10:50 AM

Rob,

SUMIF accepts just one criterion/condition that can be applied to the range to be summed. If you need more conditions, others means are needed such as an array formula.

Care to provide sample data along with crieria and what must be summed?

Aladin

Posted by Rob on July 17, 2001 10:59 AM

For Auto Insurance, Column A is fault (ours, theirs), Column B is Who Paid (Our company, other company), Column C is the amount paid that I need summed.

Thank You,
~Rob

Posted by Aladin Akyurek on July 17, 2001 11:23 AM

Multiconditional Sum

Array-enter:

=SUM((A1:A10="Ours")*(B1:B10="Our Company")*(C1:C10))

You need to hit CONTROL+SHIFT+ENTER at the same time (not just ENTER) in order to enter an array formula.

Substitute the real things for "Ours" and "Our company".

Be warned that if your range in A is too big, the performance can become an issue.

Aladin

==========

Posted by Rob on July 17, 2001 11:33 AM

Thank You (nt)