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

sorry, how about this:

=SUMPRODUCT(--($E$29:$E$41=$D$7),($B$29:$B$41=$A$9)+($B$29:$B$41=$A$18),$C$29:$C$41*$B$3)

Regards,
KL


"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