| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif with two criterias
I have mutiple sheets of information for which i want to sum values in column
p if columns c & d meet specified criteria. The formula i have at present is =(SUMPRODUCT(SUMIF(INDIRECT("'"&$AE$11:$AE$26&"'!$ d$9:$d$65536"),$A11,INDIRECT("'"&$AE$11:$AE$26&"'! p$9:p$65536")))) This works for one set of criteria but i don't know how to incorprate the second. Can any one help/ -- gibz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| I want to use the same function as SUMIF, but for two criterias | Excel Worksheet Functions | |||
| excel, how do I get sumif with two criterias? | Excel Worksheet Functions | |||
| SUMIF with 2 criterias | Excel Worksheet Functions | |||
| Sumif or Sumproduct 2 criterias not working | Excel Discussion (Misc queries) | |||
Threaded Mode
