Excel Formulas to Calculate the Sum of the Time with SUMIFS Function!!
Tags: excelformula, excelformulas
Published: 2021-05-29 02:59:54

---
title: Excel Formulas to Calculate the Sum of the Time with SUMIFS Function!!
published: true
date: 2021-05-28 05:17:12 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Sum the time with SUMIFS](https://geekexcel.com/wp-content/uploads/2021/05/Sum-thime-with-SUMIFS.png)](https://geekexcel.com/excel-formulas-to-calculate-the-sum-of-the-time-with-sumifs-function/sum-thime-with-sumifs/#main)<figcaption id="caption-attachment-45723">Sum the time with SUMIFS</figcaption>

## Generic Formula:

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

**=SUMIFS(times,range,criteria)**

## 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.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-54.png)<figcaption id="caption-attachment-45725">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-94.png)<figcaption id="caption-attachment-45724">Enter the formula</figcaption>

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

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-88.png)<figcaption id="caption-attachment-45722">Result</figcaption>

## 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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Calculate the Sum of Time Over 30 Minutes!!](https://geekexcel.com/excel-formulas-to-calculate-the-sum-of-time-over-30-minutes/)**
- **[How to Search for a Value in All Tabs in Excel Office 365?](https://geekexcel.com/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!!](https://geekexcel.com/excel-formulas-to-sum-the-time-by-week-and-project/)**
- **[How to Find the Last Column of Data in Excel Office 365?](https://geekexcel.com/how-to-find-the-last-column-of-data-in-excel-office-365/)**