| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
