Hi guys
I have a SUMIFS formula to extract number of hours worked from a specific start and end date within a months range. (A time sheet export)
=SUMIFS(D2121:D2191,C2121:C2191,">=01/05/2018",D2121:D2191,"<=31/05/2018")
Can anyone tell me how to add an additional criteria (payroll no from column A) to automatically select the cell ranges for columns C (date range) and D (hours).
I've been googling like a mad man this morning, i know the answer is out there but it's eluding me.
Thanks
I have a SUMIFS formula to extract number of hours worked from a specific start and end date within a months range. (A time sheet export)
=SUMIFS(D2121:D2191,C2121:C2191,">=01/05/2018",D2121:D2191,"<=31/05/2018")
Can anyone tell me how to add an additional criteria (payroll no from column A) to automatically select the cell ranges for columns C (date range) and D (hours).
I've been googling like a mad man this morning, i know the answer is out there but it's eluding me.
Thanks