Starting at F35, looking to sum the first 4 cells, then in the next cell sum the next 4 cells, then in the next cell sum the next 5 cells in row 35. Then repeat.
If I am summing 4 cells every time, I use the formula below - not sure how to sum 4, 4 then 5 and repeat.
=SUM(OFFSET($F$35,,(COLUMNS($F$35:F35)-1)*4,,4))
Thank you!
If I am summing 4 cells every time, I use the formula below - not sure how to sum 4, 4 then 5 and repeat.
=SUM(OFFSET($F$35,,(COLUMNS($F$35:F35)-1)*4,,4))
Thank you!