SUMPRODUCT #VALUE! Error

[juliejg1]

I have the following formula:

=SUMPRODUCT(--(Details!$X$6:$X$169>0.19),--(Details!$X$6:$X$169<0.31),(Details!$AF$6:$AG$169))

This formula is suppose to be saying:
Lookin in column X for any numbers less than .31 and greater than .19 and
for all of those matching the criteria sum up the values in columns AF and AG.
I'm getting an error #VALUE!
Any suggestions?

 

[Peo Sjoblom]

You need to use this instead if you have 2 columns

=SUMPRODUCT((Details!$X$6:$X$169>0.19)*(Details!$X$6:$X$169<0.31)*(Details!$AF$6:$AG$169))


you cannot use the built SUMPRODUCT way delimited with commas if you have
more than one column to sum, you would need the asterisk and multiply the
arrays


--


Regards,


Peo Sjoblom

 

[juliejg1]

Thanks again...works great!

You need to use this instead if you have 2 columns

=SUMPRODUCT((Details!$X$6:$X$169>0.19)*(Details!$X$6:$X$169<0.31)*(Details!$AF$6:$AG$169))


you cannot use the built SUMPRODUCT way delimited with commas if you have
more than one column to sum, you would need the asterisk and multiply the
arrays


--


Regards,


Peo Sjoblom