Forum Discussion
Solved
SUM part of SEQUENCE spill range
Hi all, I am creating a spreadsheet to track my clock-in and clock-out times per month. As part of this, I would like to be able to sum the amount of time worked per day within a given week. The set-...
Nairn1150 Easiest would be to insert a column with the ISO-week number, using =ISOWEENUM(A2#). Then, you could do something like this:
File attached.
In case anyone stumbles across this thread in the future and is still looking to use the spill operator functionality, I had a little play about with the suggestion by Riny_van_Eekelen, and I realised that the following formula works in the case of using a helper column (B) with =ISOWEEKNUM(A2#), and named range (can be substituted for regular cell references):
=IF(WEEKDAY(A2#,2)=7,SUMIF(B2#,B2#,Hours),"")
And you even add the offset back in from my original post so everything is dynamic based around the first column:
=IF(WEEKDAY(A2#,2)=7,SUMIF(B2#,B2#,OFFSET(A2#,0,3)),"")