Re: Sum product help needed with an extra variable please and than

=(SUMPRODUCT(--('Cattle Mvts'!$E$29:$E$41='Cattle Budget'!D7),--(('Cattle
Mvts'!$B$29:$B$41='Cattle Budget'!A9)+('Cattle Mvts'!$B$29:$B$41='Cattle
Budget'!A18)),('Cattle Mvts'!$C$29:$C$41)*'Feedlot Assumptions'!$B$3))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony" <Anthony@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:003932FC-A7D6-4623-8F1C-50E5CF720CE9@xxxxxxxxxxxxxxxx
> Hi KL
>
> Could you check reply all I got was my formula relating to E and C cell
> arrays not the extra help I need for the B array
>
> Thanks anthony
>
> "KL" wrote:
>
> > Hi Anthony,
> >
> > Try this:
> > =(SUMPRODUCT(--('Cattle Mvts'!$E$29:$E$41='Cattle Budget'!D7),('Cattle
> > Mvts'!$C$29:$C$41)*'Feedlot Assumptions'!$B$3))
> >
> >
> > Regards,
> > KL
> >
> >
> > "Anthony" <Anthony@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:52F631A7-DDA1-4159-A52D-B9245B575EC0@xxxxxxxxxxxxxxxx
> > > =(SUMPRODUCT(--('Cattle Mvts'!$E$29:'Cattle Mvts'!$E$41='Cattle
> > > Budget'!D7),('Cattle Mvts'!$C$29:'Cattle Mvts'!$C$41)*'Feedlot
> > > Assumptions'!$B$3))
> > >
> > > The existing formula basically says if date at D7 equals a date in the
> > > array
> > > E29 to E41 then multiply the corresponding figure in array C29 to C41
by
> > > B3.
> > > i now need to expand it to include the concept to do that if the
contents
> > > of
> > > array B29 to B41 equal the contents of either A9 or A18, otherwise
leave
> > > blank.
> > >
> > > Hope someone can help
> > >
> > > Anthony
> >
> >
> >


.

Relevant Pages