=SUMPRODUCT((ISNUMBER(SEARCH({"Yes";"No"},A1:Z1)))*({1.5;1})*(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:07F3AD20-CE51-4047-970B-19D7A84758E8@microsoft.com...
> 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?
> > > >
> > > >
> > > >
> >
> >
> >