Forum Discussion

Copper Contributor

Feb 20, 2026

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...

office 365

IlirU

Iron Contributor

Feb 23, 2026

Hi caltana,

Use below formula in cell N2:

=BYROW(A2:A7, LAMBDA(a, SUM(CHOOSEROWS(CHOOSECOLS(B2:M7, SEQUENCE(a)), ROWS(A2:a)))))

HTH

IlirU