| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif with two criterias
What are your criteria for columns C and D and I can assist.
"gibz" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif with two criterias
perhaps a simpler version
=sumproduct((c2:c22="joe")*(d2:d22=35)*p2:p22) -- Don Guillett SalesAid Software "gibz" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sumif with two criterias
Hi,
Column c is a number 2,3,4 etc and column d is text (i.e TP010) Don, your formula works fine on a single sheet but i have approx 35 sheet hence why the sheets are named in a specifed range. Thanks for your help. -- gibz "Barb Reinhardt" wrote: What are your criteria for columns C and D and I can assist. "gibz" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
