Sum product help needed with an extra variable please and thankyou

=(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

  • Re: Sum product help needed with an extra variable please and thankyou
    ... Regards, ... > The existing formula basically says if date at D7 equals a date in the ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Excel Macro Help
    ... Here's the breakdown: ... To make is simple K1 on this formula is only a number above my array. ... equals something other than 1 it will lookup in a different array. ... The formula above works great but when I try to expand it to the three ...
    (microsoft.public.excel.programming)
  • RE: Number of Items in Array
    ... array', ... $#array equals 1 less than scalar. ... Charles K. Clarkson ... Prev by Date: ...
    (perl.beginners)
  • Stumped with select function
    ... table name equals 1st item in array ... does the zero seem to be causing me problems? ... Prev by Date: ...
    (comp.lang.php)
  • Re: Using INDEX twice??
    ... ...and then use conditional formatting to hide any error value that may ... to the first cell in the range) which meets the specified criteria. ... IF function returns an array of numbers, ... FALSE*TRUE equals 0 ...
    (microsoft.public.excel.worksheet.functions)
Loading