Let me show you the first part of my array:
A B C D X Y
1 Yes No Yes Yes 1.5 1
2 6 3 2 2
3 2 4 6 3

A1:D3 is my array. X and Y are the multipliers. The calculation for this
would be :
6*2*1.5+ 3*4*1+ 2*6*1.5+ 2*3*1.5. Thus, if A1:D1 is "Yes" then the
corresponding product multiplies by 1.5. If A1:D1 is "No" then it multiplies
by 1.



"Bob Phillips" wrote:

> What multiplier?
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> "Ben010" <Ben010@discussions.microsoft.com> wrote in message
> news:E4221808-ACF8-49A2-9ED2-2F0A52E9A05E@microsoft.com...
> > Bob--
> > Thanks. My original query was probably not clear. If A1:Z1 is "Yes" then
> I
> > want the cell to compute to your answer times a multiplier. If "No" I
> want
> > the cell to compute to exactly your answer (multiplier =1).
> >
> > Ben
> >
> > "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?
> > >
> > >
> > >
>
>
>