summing multiple ranges when more than one cell meets the criteria

[clarky]

Hi, I am trying to sum the number of hours each staff member does each month by funder code where the date and funder code needs to be checked first.

The timesheets are fortnightly so their periods (as in the attached example) may contain data from either the previous month or the following month (in the attached example 20th July to 2nd August) and unfortunately only one date entry covers 10 rows so a simple sumifs() only picks up one amount on the same row as the date.

I am not permitted to make changes to the timesheet format so I have been trying to get a formula that looks at the date in column A to see if it is between the first and last day of a particular month which I can manage but then I don’t know how to get the summing of all the 10 rows in column C that are relevant for that date (there are always 10 rows to check).

And I need to check all the dates on the sheet to get the complete total.

I hope this makes sense. Thanks for the opportunity to ask for help.

 

[NARAYANK991]

Hi ,

You say that the code also needs to be checked ; does this mean you want to subtotal on the code , or do you want a subtotal by date alone ?

Narayan

 

[clarky]

Hi ,

You say that the code also needs to be checked ; does this mean you want to subtotal on the code , or do you want a subtotal by date alone ?

Narayan

Hi Narayan, thanks for the question. Subtotal by code please.

So in the example I would like 4 separate subtotals for July. One summing all the 11 coded hours in July and the same for 15,21 and 22.