In this article, we will discuss the formulas to sum the values from a range by a group 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:
- To sum the values by a group in Excel, use the below formula.
=IF(A2=A1,””,SUMIF(A:A,A2,B:B))
Syntax Explanations:
- IF – The Excel** IF function** return one value for a TRUE result, and another for a FALSE result.
- SUMIF – It will return the sum of cells that meet a single condition. Read more on the SUMIF Function.
- 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.
- Range – It represents the input range from your workbook.
- Criteria – It is the condition that is used to sum the values.
Example:
- Let’s consider the below image to sum the values by a group.
- In this example, we will give the input values in Columns B and C.
- Then, enter the given formula in the formula bar section.
- After applying the formula, we will get the result as shown in the below image.
Verdict:
From this article, we guided you to know the formulas used to sum the values by a group in Excel Office 365. Hope you like this article. Kindly, share your feedback in the comment section. Thanks for reading!! Keep learning on Geek Excel!! *and Excel Formulas *!!
Top comments (0)