How to Use SUM Formula in Excel — 3 Easy Methods for Beginners
If you are just starting with Microsoft Excel, the SUM formula is the very first formula you must learn. It is one of the most used Excel functions in offices, schools, and businesses all over the world. In this article, you will learn 3 easy ways to SUM in Excel — completely free!
📺 Watch the full free tutorial above by Excel with Abid
What is the SUM Formula in Excel?
The SUM formula in Excel is used to add numbers together. Instead of manually adding each number one by one, the SUM formula does it automatically in just seconds. Whether you have 5 numbers or 5000 numbers, SUM calculates the total instantly.
3 Ways to Use SUM in Excel
✅ Method 1 — SUM Formula
The most common way to add numbers in Excel is by typing the SUM formula directly into a cell.
Syntax:
=SUM(A1:A10)
This formula adds all numbers from cell A1 to A10. You can change the cell range based on your data.
Example:
A1 = 100 A2 = 200 A3 = 300 =SUM(A1:A3) = 600
✅ Method 2 — AutoSum Shortcut
Did you know you can add numbers in Excel with just one keyboard shortcut? Simply click on the empty cell below your data and press:
ALT + =
Excel will automatically detect your data and insert the SUM formula for you. This is the fastest way to SUM in Excel and saves a lot of time every day!
✅ Method 3 — Quick Sum from Status Bar
This is a hidden Excel trick that most people never use. Simply select any cells containing numbers and look at the bottom status bar of Excel. You will instantly see the SUM, AVERAGE, and COUNT of your selected cells — without typing any formula at all!
This method is perfect when you just want to quickly check a total without adding a formula to your spreadsheet.
Why is the SUM Formula Important?
The SUM formula is used in almost every Excel spreadsheet. Here are some real life uses:
- 📊 Calculating total sales in a business
- 💰 Adding up monthly expenses and budget
- 🎓 Calculating total marks in a result sheet
- 📦 Adding up inventory quantities
- 🏦 Summing up bank transactions
- 🧾 Calculating total salary of employees
- 🛒 Adding up prices in a shopping list
SUM Formula Tips & Tricks
- 💡 You can SUM non-adjacent cells: =SUM(A1,B5,C10)
- 💡 You can SUM entire column: =SUM(A:A)
- 💡 You can SUM multiple ranges: =SUM(A1:A10,B1:B10)
- 💡 SUM ignores text and empty cells automatically
- 💡 Use SUMIF to SUM with conditions
Quick Summary Table
| Method | How to Use | Best For | Speed |
|---|---|---|---|
| SUM Formula | =SUM(A1:A10) | Any situation | ⚡⚡⚡ |
| AutoSum Shortcut | ALT + = | Fastest method | ⚡⚡⚡⚡⚡ |
| Status Bar | Select cells & look at bottom | Quick check only | ⚡⚡⚡⚡ |
Frequently Asked Questions (FAQ)
❓ What does the SUM formula do in Excel?
The SUM formula adds all numbers in a selected range of cells and returns the total value.
❓ What is the shortcut for SUM in Excel?
The keyboard shortcut for AutoSum in Excel is ALT + = on Windows.
❓ Can SUM work with text cells?
No. The SUM formula automatically ignores text and empty cells. It only adds numeric values.
❓ What is the difference between SUM and SUMIF?
SUM adds all numbers in a range. SUMIF adds only those numbers that meet a specific condition. For example, adding sales only from a specific region.
❓ Is SUM formula available in Google Sheets?
Yes! The SUM formula works exactly the same way in Google Sheets as it does in Microsoft Excel.
Watch More Free Excel Tutorials
If you found this tutorial helpful, make sure to subscribe to Excel with Abid on YouTube for more free Excel tips, formulas, shortcuts, and tutorials every week — 100% FREE!
💡 About Excel with Abid: Excel with Abid is a free Excel learning channel for students and freshers who want to learn Microsoft Excel and Google Sheets without paying for expensive courses. Our mission is to make Excel education free and accessible for everyone. New videos every week — completely FREE!
Tags: Excel SUM formula, how to use SUM in Excel, Excel for beginners, Excel tutorial, Microsoft Excel, AutoSum shortcut, Excel tips, free Excel course, Excel with Abid, learn Excel free