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...
Hello caltana,
Use this dynamic spill formula for VOWD: =MAP(A2:A7, B2:M7, LAMBDA(fm, row, SUM(IFERROR(--TAKE(row, fm), 0)))) – MAP processes each row, fm is the Fore Month, row is the monthly data, TAKE(row, fm) picks the first fm months, IFERROR(--…,0) converts any "-" to 0, and SUM adds them. It spills automatically, sums the first N months per Fore Month, and needs no helper columns.