Help with a formula to sum the hours by month by project

Jen Iliff

Hi all - I need some help building a formula that will show the sum of hours by month (see attached summary sheet - columns Jan 2021 Hours / Feb 2021 Hours) by project. The data that it needs to sum is on the Time Tracking Entry sheet. The unique identifier on both sheets is the "ID". Thanks in advance for any help you can provide.

Time Tracking Entry.JPG

Bassam Khalil

Hi @Jen Iliff

Hope you are fine,please try the following formula

=SUMIFS({Hours}, {ID}, ID@row, {Today's Date}, MONTH(@cell) = 1)