Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

=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

Check out our Excel Resources

Re: =sumif(*)

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

Re: =sumif(*)

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

Multiconditional Sum

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

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

==========

Thank You (nt)

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.