Forum Discussion
Formula Question, Autofill Question?
So my line of work uses a fairly simple tracking tool for production, yet every year we have to do an extension exercise with the data sorting portion. (weekly totaling, basic sum formulas) I am ask...
Wesjenks SEQUENCE() function will generate that number series jump by step 7. To sum from different sheet you will need INDIRECT() function. To make it dynamic spill array function use MAP() or BYROW() function. Spill array means you do not need to drag the formula manully. It will auto adjust formula when you enter new data to Column A. See the attached file for full formula.
=MAP("'DailyInput'!B"&SEQUENCE(COUNTA(A4:A1000),1,4,7)&":"&"B"&SEQUENCE(COUNTA(A4:A1000),1,10,7),LAMBDA(x,SUM(INDIRECT(x))))