Here, we will describe the simple formulas to sum the values based on the multiple criteria in Excel Office 365. Let’s get 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:
- The below formula will help to sum the values based on multiple criteria.
=SUMIFS(sum_rng, crit_rng1, crit1, crit_rng2, crit2)
Syntax Explanations:
- SUMIFS – The Excel SUMIF Function will help to sum the cells that meet multiple conditions or criteria.
- Comma symbol (,) – It is a separator which helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
- Sum_Range – It represents the input values given in the worksheet.
- Criteria – It is the specific value or criteria that helps to sum the values.
Example:
- Here, we will show how to sum the values based on multiple criteria.
- In the below image, we will give the input values in Column B , Column C , and Column D.
- Then, enter the given formula in the formula bar section.
- Finally, it will display the result in Cell G3.
Summary:
In this article, we guided you to learn the simple formula used to sum the values in the cells based on multiple criteria in Excel Office 365. Hope that this article is useful to you. If you have any doubts/queries, feel free to share it with us. To know further updates keep in touch with our website Geek Excel and Excel Formulas !!
Top comments (0)