📊 Excel Basics #10 – SUM() Function

The SUM() function is one of the most commonly used Excel functions. It quickly adds numbers without writing long formulas.

📌 What is the SUM() Function?
SUM() adds the values in one or more cells.

Syntax:
=SUM(number1, [number2], ...)

You can use numbers, cell references, or ranges.

📌 Example 1 – Add Individual Numbers
Formula:

=SUM(10,20,30)

Result: 60

📌 Example 2 – Add Cell Values
A
100
200
300

Formula:

=SUM(A2,A3,A4)

Result: 600

📌 Example 3 – Add a Range
Instead of selecting each cell individually, use a range.
Formula:

=SUM(A2:A10)

This adds all values from A2 to A10.

📌 Example 4 – Add Multiple Ranges
Formula:

=SUM(A2:A5,C2:C5)

This adds both ranges together.

📌 Real-World Example
Product Sales
Laptop 50000
Mouse 5000
Keyboard 8000
Monitor 25000

Formula:

=SUM(B2:B5)

Result: 88000

📌 AutoSum Shortcut
Excel can automatically insert the SUM() function.

Go to: Home → AutoSum (∑)
Or use the shortcut: Alt + =

Excel automatically selects the nearby range.

📌 Common Mistakes
• Including blank cells unintentionally.
• Selecting the wrong range.
• Typing numbers as text (they won't be added).

✅ Best Practices
• Use ranges (A2:A100) instead of listing individual cells.
• Double-check the selected range before pressing Enter.
• Use AutoSum (Alt + =) to save time.
• Keep related numbers together in one column or row for easier calculations.

Double Tap ❤️ For More