Enter this formula in E2 and fill down:
=IF(TODAY()-365<C2,D2,0)
Enter the Label ID: in cell A6
Enter the ID you want to sum in B6
Enter the label Hours: in cell A7
Enter this formula in cell B7:
=SUMPRODUCT(--(B2:B4=B6)*(E2:E4))
NOTE: all of the data provided will provide a sum since it's all less than a year old...
Bookmarks