This is what the formulas look like correctly.
Cell B2 =SUM(Daily!B2:B6)
Cell B3 =SUM(Daily!B7:B11)
Cell B4 =SUM(Daily!B12:B16)
When I highlight those 3 cells and drag down I expect Cell B5 formula to fill as =SUM(Daily!B17:B21)
Instead dragging down makes it populate as =SUM(Daily!B5:B9)
How do I fix this so I can drag fill that column?
Also sorry if I didn't post this correct way. First time here.
Cheers
Use new dynamic array formulas to get results automatically. Try-
=MAP(SEQUENCE(100,1,2,5),SEQUENCE(100,1,6,5),LAMBDA(x,y,SUM(INDEX(Daily!B:B,x):INDEX(Daily!B:B,y))))