Forum Discussion
Excel array question - spill VOWD based on forecast month
Hi, Can I have your help on a spilled question? I have the following table with information. Fore Month Jan-26 Feb-26 Mar-26 Apr-26 May-26 Jun-26 Jul-26 Aug-26 Sep-26 Oct-2...
=MAKEARRAY(ROWS(A2:A7), 1, LAMBDA(r,c,
LET(
fore_month, INDEX(A2:A7, r),
SUMPRODUCT(N(COLUMN(B1:M1)<=COLUMN(B1)+fore_month-1), INDEX(B2:M7, r, 0)))))
Based on your description, the logic is to sum the values from the first N months (where N equals the "Fore Month" value) for each pair of rows.