DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Formulas to Sum the Values by Group in Excel Office 365!!

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

Formulas to sum by groups
Formulas to sum by groups

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.

Example
Example

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 *!!

Related Articles:

Top comments (0)