View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Madiya Madiya is offline
external usenet poster
 
Posts: 239
Default SUMPRODUCT - small correction required

I am facing small problem in the following formula.
=SUMPRODUCT(-(FE!$A$2:$A$65000=A7),-(FE!$B$2:$B$65000=B7),-(FE!$C$2:$C$65000="BSE"),FE!$E$2:$E$65000)

The problem is I am always getting a -ve value whereas the actual value
is +ve.
If I try to change any of the "-" (minus) sign in above formula, it
returns zero.

Please help.

Regards,
Madiya