Forum Discussion
caltana
Feb 20, 2026Copper Contributor
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...
SnowMan55
Feb 22, 2026Bronze Contributor
There is no need to use a LAMBDA function to accomplish this. The OFFSET function will suffice. See this workbook: 2026-02-22 Anna summing variable ranges.xlsx