Bob....Thanks a bunch! Bookmarked your site!

Hans


Bob Phillips wrote:
> I have written a page on that. See
> http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
> explanation.
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> <hansjhamm@yahoo.com> wrote in message
> news:1150135331.115132.21800@f6g2000cwb.googlegroups.com...
> > 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?
> >