sumif using multiple criteria

[Guest]

How can I use the sumif using more than one criteria. For example:

Sum column C if column A = 5 AND if column B =10

 

[Dave O]

The formula is (you'll need to adjust the ranges, of course)
=SUMPRODUCT(--(A1:A10=5),--(B1:B10=10),C1:C10)

For a detailed explanation, do a search on DOUBLE UNARY SUMPRODUCT at
this site:
http://groups.google.com/group/microsoft.public.excel.misc?hl=en&lr=&ie=UTF-8&oe=UTF-8

 

[Pete_UK]

Try this array* formula:

=SUM(IF((A1:A100=5)*(B1:B100=10),C1:C100))

*As this is an array formula, then once you have typed it in (or
subsequently edit it) you must use CTRL-SHIFT-ENTER (CSE) rather than
just ENTER. If you do this correctly, then Excel will wrap curly braces
{ } around the formula when viewed in the formula bar - you must not
type these yourself.

Hope this helps.

Pete

 

[Bob Phillips]

I think (hope <g>) that you mean

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

your link pulls up this thread (amongst others)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)