Track hours for a specific task in a specific month

Magda

Hi everyone,

So I am trying to track the hours I spend doing task called e.g. "Test 1" in a given month. I have a separate spreadsheet with Dates (Month, day, year), Duration (in Hours) and column for Category (where I have "Test 1").

Could you help me with a formula to track this?

Thank you!

Paul Newcome

You would use a SUMIFS.

=SUMIFS({Hours}, {Category}, @cell = "Test 1", {Dates}, AND(IFERROR(MONTH(@cell), 0) = 8, IFERROR(YEAR(@cell), 0) = 2023))

Paul Newcome

You would use a SUMIFS.

=SUMIFS({Hours}, {Category}, @cell = "Test 1", {Dates}, AND(IFERROR(MONTH(@cell), 0) = 8, IFERROR(YEAR(@cell), 0) = 2023))

Magda

Thank you Paul! It worked :)

Paul Newcome

Happy to help. 👍️