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 |
SUMPRODUCT - small correction required
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 |
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 |
All times are GMT +1. The time now is 11:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com