Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT not working.
can someone please help me understand what is wrong with the following
formula? =SUMPRODUCT((Sheet1!$C$2:$C$3515=A2)*(Sheet1!$B$2: $B$3515="-2")) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT not working.
The syntax is correct.
Try rmoving the quotes and see it that makes a difference: =SUMPRODUCT((Sheet1!$C$2:$C$3515=A2)*(Sheet1!$B$2: $B$3515=-2)) -- Biff Microsoft Excel MVP "Gaurav" wrote in message ... can someone please help me understand what is wrong with the following formula? =SUMPRODUCT((Sheet1!$C$2:$C$3515=A2)*(Sheet1!$B$2: $B$3515="-2")) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT not working.
Try it without the quotes around -2
Gord Dibben MS Excel MVP On Thu, 25 Jun 2009 14:14:05 -0600, "Gaurav" wrote: can someone please help me understand what is wrong with the following formula? =SUMPRODUCT((Sheet1!$C$2:$C$3515=A2)*(Sheet1!$B$2 :$B$3515="-2")) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Not Working | Excel Discussion (Misc queries) | |||
SUMPRODUCT not working | Excel Discussion (Misc queries) | |||
Sumproduct not working | Excel Worksheet Functions | |||
Sumproduct Not Working | Excel Worksheet Functions | |||
sumproduct not working | Excel Worksheet Functions |