Excel Formulas to Calculate the Sum of the Time with SUMIFS Function!!

Sometimes we need to find the sum of time values having multiple criteria. SUMIFS function allows you to sum the values with multiple conditions that need to be satisfied. So we made a formula to calculate the sum of the time with the SUMIFS function in Excel. Let’s begin!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

The below formula will help you to calculate the sum of the times with the SUMIFS function.

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.

Range – It specifies the input data from your worksheet.

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

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

Practical Example:

Let’s consider the below example image.

Here, we will enter the input values in Column B and Column C.

Now we need to sum the times based on the given criteria.

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.

Conclusion:

Here, we have discussed how to sum the time with the SUMIFS function in Excel. I hope that this article is helpful to you. Don’t forget to share your worthwhile feedback with us.

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

Read Ahead:

Excel Formulas to Calculate the Sum of Time Over 30 Minutes!!

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

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

How to Find the Last Column of Data in Excel Office 365?