Posted to microsoft.public.excel.programming
|
|
SUMPRODUCT - small correction required
Thanks for your reply. Its great.
Regards,
Madiya
Bob Phillips wrote:
You need a double unary
=SUMPRODUCT(--(FE!$A$2:$A$65000=A7),--(FE!$B$2:$B$65000=B7),
--(FE!$C$2:$C$65000="BSE"),FE!$E$2:$E$65000)
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Madiya" wrote in message
oups.com...
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
|