Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif using multiple criteria
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif using multiple criteria
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/micro...UTF-8&oe=UTF-8 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif using multiple criteria
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 RMires wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif using multiple criteria
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) "Dave O" wrote in message ups.com... 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/micro...UTF-8&oe=UTF-8 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple rows of data based on criteria | Excel Worksheet Functions | |||
SUMIF multiple criteria | Excel Discussion (Misc queries) | |||
SUMIF with multiple criteria | Excel Worksheet Functions | |||
SUMIF in multiple columns based on other criteria in Excel? | Excel Discussion (Misc queries) | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) |