Notice all three criteria use mixed references to lock rows and columns as needed to allow copying.
Home » PostsSum time by week and projectTo sum up hours by week and project, you can use the SUMIFS function. In the example shown, the formula in G5 is: =SUMIFS(time,date,">="&$F5,date,"April 14, 2025 · 1 min · 17 words · Kevin BakerNotice all three criteria use mixed references to lock rows and columns as needed to allow copying.