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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >