I found it a bit hard to phrase this question, so here's a screenshot:

My timesheet

I'm trying to create a timesheet for our employees and would like to have a cumulative sum function that sums up the number of hours worked in each week. This should be automatic, depending on the calendar week (first column).

So, for instance, I would like to sum up all hours worked in week 4, but if someone were to work for only two days, the formula would have to work too.

Is that possible using a formula?


=SUMPRODUCT(QUERY(A$2:F, "select F where A matches '"&INDIRECT("A"&ROW())&"'"))


Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.