Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF summing multiple columns
I have the following formula in cell E9:
=SUMIF(Details!$X$6:$X$167,""&0.3,Details!$AF$6:$ AG$169) It seems there is a problem with the SUMIF summing more than one column (AF6:AG169). Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF summing multiple columns
167 169 -- Don Guillett Microsoft MVP Excel SalesAid Software "juliejg1" wrote in message ... I have the following formula in cell E9: =SUMIF(Details!$X$6:$X$167,""&0.3,Details!$AF$6:$ AG$169) It seems there is a problem with the SUMIF summing more than one column (AF6:AG169). Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF summing multiple columns
I'm confused by your answer
"Don Guillett" wrote: 167 169 -- Don Guillett Microsoft MVP Excel SalesAid Software "juliejg1" wrote in message ... I have the following formula in cell E9: =SUMIF(Details!$X$6:$X$167,""&0.3,Details!$AF$6:$ AG$169) It seems there is a problem with the SUMIF summing more than one column (AF6:AG169). Any suggestions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF summing multiple columns
What Don meant by "167 169" is that in SUMPRODUCT the arrays must be the
same length. Yours are not, as one has 162 rows and the other has 164. -- David Biddulph "juliejg1" wrote in message ... I'm confused by your answer "Don Guillett" wrote: 167 169 -- Don Guillett Microsoft MVP Excel SalesAid Software "juliejg1" wrote in message ... I have the following formula in cell E9: =SUMIF(Details!$X$6:$X$167,""&0.3,Details!$AF$6:$ AG$169) It seems there is a problem with the SUMIF summing more than one column (AF6:AG169). Any suggestions? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF summing multiple columns
It doesn't really matter since the OP is using SUMIF and wants to sum 2
columns (AF:AG) it will only work for one. This will work =SUMPRODUCT((Details!$X$6:$X$1670.3)*(Details!$AF $6:$AG$167)) and that is where same sized arrays are important. SUMIF will gladly swallow it -- Regards, Peo Sjoblom "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... What Don meant by "167 169" is that in SUMPRODUCT the arrays must be the same length. Yours are not, as one has 162 rows and the other has 164. -- David Biddulph "juliejg1" wrote in message ... I'm confused by your answer "Don Guillett" wrote: 167 169 -- Don Guillett Microsoft MVP Excel SalesAid Software "juliejg1" wrote in message ... I have the following formula in cell E9: =SUMIF(Details!$X$6:$X$167,""&0.3,Details!$AF$6:$ AG$169) It seems there is a problem with the SUMIF summing more than one column (AF6:AG169). Any suggestions? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF summing multiple columns
Thank you!
"Peo Sjoblom" wrote: It doesn't really matter since the OP is using SUMIF and wants to sum 2 columns (AF:AG) it will only work for one. This will work =SUMPRODUCT((Details!$X$6:$X$1670.3)*(Details!$AF $6:$AG$167)) and that is where same sized arrays are important. SUMIF will gladly swallow it -- Regards, Peo Sjoblom "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... What Don meant by "167 169" is that in SUMPRODUCT the arrays must be the same length. Yours are not, as one has 162 rows and the other has 164. -- David Biddulph "juliejg1" wrote in message ... I'm confused by your answer "Don Guillett" wrote: 167 169 -- Don Guillett Microsoft MVP Excel SalesAid Software "juliejg1" wrote in message ... I have the following formula in cell E9: =SUMIF(Details!$X$6:$X$167,""&0.3,Details!$AF$6:$ AG$169) It seems there is a problem with the SUMIF summing more than one column (AF6:AG169). Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF, One criteria multiple columns | Excel Discussion (Misc queries) | |||
SUMIF and multiple columns | Excel Discussion (Misc queries) | |||
SUMIF with multiple criteria, by columns | Excel Worksheet Functions | |||
SUMIF over multiple columns | Excel Worksheet Functions | |||
Sumif over multiple columns | Excel Worksheet Functions |