Excel Formulas to Sum the Time by Week and Project ~ Easy Tricks!!

Excel allows us to sum the values based on the week number by using SUMIFS and WEEKNUM functions. In this article, I introduce some formulas which can quickly calculate the sum of time by week and project in Excel. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

If you want to sum the times by week and project, you can use the below formula.

*=SUMIFS(time,date,”>=”&A1,date,”<“&A1+7,project,”A”) *

Syntax Explanations:

SUMIFS – The Excel SUMIFS Function will help to sum the cells that meet multiple conditions or criteria.

Time – It specifies the input times from your worksheet.

*Date * – It specifies the input dates from your worksheet.

Comma symbol (,) – It is a separator that helps to separate a list of values.

Project – It represents the project name.

Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

First, we will enter the input values in Column B to Column D.

Here, we have to calculate the total times based on the given week and project name.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Wrap-Up:

So yeah guys this is how we can calculate the sum of times by week and project in Excel. Hope you like it. Let me know if you have any doubts regarding this article or any other Excel/VBA topic.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Also:

Excel Formulas to Calculate the Sum of Race Time Splits ~ Quick Tricks!!

How to Search for a Value in All Tabs in Excel Office 365?

Excel Formulas to Parse Time String to Time ~ A Complete Tutorial!!

Excel Formulas to Calculate the Sum by Fiscal Year ~ Quick Method!!