SUMPRODUCT #VALUE! Error
 

I have the following formula:

=SUMPRODUCT(--(Details!$X$6:$X$1690.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?

SUMPRODUCT #VALUE! Error
 

You need to use this instead if you have 2 columns

=SUMPRODUCT((Details!$X$6:$X$1690.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" wrote in message
...
I have the following formula:

=SUMPRODUCT(--(Details!$X$6:$X$1690.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?

SUMPRODUCT #VALUE! Error
 

Thanks again...works great!

"Peo Sjoblom" wrote:

You need to use this instead if you have 2 columns

=SUMPRODUCT((Details!$X$6:$X$1690.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" wrote in message
...
I have the following formula:

=SUMPRODUCT(--(Details!$X$6:$X$1690.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?