Different Methods of Using SUM in Microsoft Excel

1. Introduction

The SUM function is used in Excel to calculate the total of numbers.

In the provided notes, SUM is used in practical calculations such as Course Fee, Admission Fee, Prospectus Fee, Examination Fee and other fee-related calculations.

For example, if different fees are entered in cells:

Course Fee        = ₹20,000
Admission Fee     = ₹1,000
Prospectus Fee    = ₹200
Examination Fee   = ₹800

These amounts can be added together to calculate the Total Fee.

2. Method 1 — SUM with a Cell Range

The most common method is to use SUM with a continuous range of cells.

Formula:

=SUM(B2:B5)

Here:

B2:B5
  ↓
B2
B3
B4
B5

Excel adds all the values from B2 to B5.

Example:

Formula:

=SUM(B2:B5)

Result:

₹22,000

3. Method 2 — SUM with Individual Cell References

You can also specify individual cells inside the SUM function.

Formula:

=SUM(B2,B3,B4,B5)

This tells Excel to add the values from:

B2 + B3 + B4 + B5

Example:

B2 = ₹20,000
B3 = ₹1,000
B4 = ₹200
B5 = ₹800

Formula:

=SUM(B2,B3,B4,B5)

Result:

₹22,000

4. Method 3 — Direct Addition Using +

The same values can also be added without using the SUM function.

Formula:

=B2+B3+B4+B5

Excel directly adds the values stored in these cells.

Example:

20,000 + 1,000 + 200 + 800
              ↓
           ₹22,000

5. Method 4 — SUM with a Horizontal Range

SUM can also be used when the values are arranged horizontally across columns.

For example:

Formula:

=SUM(B2:E2)

Result:

₹22,000

So SUM works with both:

Vertical Range   → =SUM(B2:B5)

Horizontal Range → =SUM(B2:E2)

6. Method 5 — SUM with Different Ranges

When required, multiple ranges can be included in one SUM formula.

Example:

=SUM(B2:B5,D2:D5)

This adds the values from both ranges:

B2:B5
   +
D2:D5

This method is useful when the required data is stored in separate ranges.

7. SUM Methods — Formula Chart

8. Course Fee Practical Example

Suppose the worksheet contains:

Method 1

=SUM(B2:B5)

Method 2

=SUM(B2,B3,B4,B5)

Method 3

=B2+B3+B4+B5

All three can produce:

₹22,000

9. Why Use SUM?

Using SUM is convenient because you can total a range of values without manually writing every addition.

For example:

=SUM(B2:B20)

adds all values from B2 through B20.

If the data is organized in a continuous range, this makes the formula easier to read and maintain.

10. Easy Way to Remember

             SUM
              ↓
       ┌──────┼──────┐
       ↓      ↓      ↓
     Range  Cells   + Operator
       ↓      ↓      ↓
 =SUM(B2:B5)  =SUM(B2,B3,B4)
                       ↓
                 =B2+B3+B4+B5

Main Rule:

SUM = Total of Numbers

⭐ Quick Revision

=SUM(B2:B5)
        ↓
   Range Method

=SUM(B2,B3,B4,B5)
        ↓
 Individual Cell Method

=B2+B3+B4+B5
        ↓
 Direct Addition Method