SUMIF summing multiple columns

[juliejg1]

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?

 

[Don Guillett]

167 169

 

[juliejg1]

I'm confused by your answer

167 169
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[David Biddulph]

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.

 

[Peo Sjoblom]

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$167>0.3)*(Details!$AF$6:$AG$167))


and that is where same sized arrays are important. SUMIF will gladly swallow
it


--


Regards,


Peo Sjoblom

 

[juliejg1]

Thank you!

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$167>0.3)*(Details!$AF$6:$AG$167))


and that is where same sized arrays are important. SUMIF will gladly swallow
it


--


Regards,


Peo Sjoblom