Bob,

I was reading thru some of the posts and saw your response...I have a
question. I use sumproduct alot, but I do not/have not used the (--
What does this do exactly?

Thanks,

Hans

Bob Phillips wrote:
> =SUMPRODUCT(--(A1:Z1="Yes"),A2:Z2,A3:Z3)
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> "Ben010" <Ben010@discussions.microsoft.com> wrote in message
> news:25A17369-354B-41DD-9C4E-538D061F4C7C@microsoft.com...
> > I want to get the sumproduct of two rows of numbers based on an IF
> condition
> > in a related row. The formula would look like this:
> > =Sumproduct(a2:z2, a3:z3)* Multiplier if a1:z1="Yes", otherwise Multiplier
> =1
> > So if a1="Yes" then the product would be a2*a3*M; if b1<>"Yes" then the
> > product would be b2*b3*1. Any ideas?