Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT #VALUE! error | Excel Worksheet Functions | |||
SUMPRODUCT #N/A error | Excel Discussion (Misc queries) | |||
Sumproduct value error | Excel Worksheet Functions | |||
Sumproduct error | Excel Worksheet Functions | |||
SUMPRODUCT ERROR | Excel Discussion (Misc queries) |