View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
juliejg1 juliejg1 is offline
external usenet poster
 
Posts: 81
Default 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?