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")) |
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")) |
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")) |
All times are GMT +1. The time now is 09:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com