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?
|