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...
=BYROW(A2:M7, LAMBDA(r, SUM(TAKE(DROP(r,,1),,INDEX(r,1)))))
=MAP(A2:A7, LAMBDA(x, SUM(OFFSET(x, 0, 1, 1, x))))
Either one of these formulas can work for you, but I personally avoid OFFSETs just due to the recalculation requirements which can be resource heavy once you have 50,000+ resource points. If this is all the data you have, either formula should work perfectly.