How to use SUM | Function in Excel | Excel SUM Example  

To quickly get the total of a range of cells or values, Excel has several sum functions. To do calculations and analyze data in spreadsheets, several functions are necessary. Here are some examples of how to utilize some of the most often-used sum functions in Excel:

 

1. SUM:

The SUM function is perhaps the most basic and widely used in Excel. It adds up a range of cells or values and returns the total sum.

 

Example:

```

=SUM(A1:A5)

```

This formula calculates the sum of the values in cells A1 through A5.

 

2. SUMIF:

The SUMIF function allows you to sum values in a range that meets specific criteria. You provide a range, a criteria, and a range of values to sum if the criteria are met.

 

Example:

```

=SUMIF(B2:B10, ">10", C2:C10)

```

This formula calculates the sum of values in the range C2:C10 where the corresponding value in the range B2:B10 is greater than 10.

 

3. SUMIFS:

Similar to SUMIF, the SUMIFS function allows you to sum values based on multiple criteria. You can specify multiple ranges and criteria to determine which values to sum.

 

Example:

```

=SUMIFS(C2:C10, B2:B10, ">10", D2:D10, "<>0")

```

This formula calculates the sum of values in the range C2:C10 where the corresponding values in the range B2:B10 are greater than 10 and the corresponding values in the range D2:D10 are not equal to zero.

 

4. SUMPRODUCT:

The SUMPRODUCT function multiplies corresponding components in the given arrays and returns the sum of those products. It is often used for array calculations.

 

Example:

```

=SUMPRODUCT(A2:A5, B2:B5)

```

This formula multiplies each value in the range A2:A5 by the corresponding value in the range B2:B5 and returns the sum of those products.

 

5. SUMSQ:

The SUMSQ function returns the sum of the squares of the arguments. It is useful for calculating the sum of squared values.

 

Example:

```

=SUMSQ(A2:A5)

```

This formula calculates the sum of the squares of the values in the range A2:A5.

 

6. SUMX2MY2:

The SUMX2MY2 function returns the sum of the differences of squares of corresponding values in two arrays. It is often used in statistical calculations.

 

Example:

```

=SUMX2MY2(A2:A5, B2:B5)

```

This formula calculates the sum of the differences of squares of corresponding values in the ranges A2:A5 and B2:B5.

 

These are just several of the Excel sum functions that are available. Every function has a unique set of applications, and they may all be used in combination with other functions to process and analyze your data in complicated ways.