What You’ll Learn
- ✓ What a formula is and how the equals sign works
- ✓ How to use the Excel SUM formula with AutoSum shortcut
- ✓ How the AVERAGE, COUNT, MIN and MAX functions work
- ✓ Why cell references make your formulas smarter
- ✓ How to spot and fix the most common beginner errors
Basic formulas in Excel are the single most powerful skill a beginner can learn — and they are far simpler than most people expect. Picture this: your manager drops a spreadsheet on your desk and says “can you just total these up and find the average?” You open Excel, stare at the grid, and your mind goes blank. Once you know the five formulas in this lesson, that blank feeling never comes back.
Here’s the thing — most people assume Excel formulas are complicated. They are not. Every single formula you will learn here follows the same simple pattern, and once you see it once, it clicks for everything else. SUM, AVERAGE, COUNT, MIN, MAX: these five cover the vast majority of everyday spreadsheet tasks.
By the end of this lesson, you will know exactly how to write formulas in Excel from scratch, use all five functions with genuine confidence, and spot and fix the common errors that make beginners panic. Let’s get into it.
What Is a Formula in Excel?
A formula in Excel is an instruction you type into a cell that tells Excel to calculate something. Instead of doing the math yourself and typing a static answer, you write a formula and let Excel handle it automatically.
The real magic? If the numbers in your spreadsheet change, the formula result updates instantly. No recalculating. No re-typing. Just accurate results, always.
The Golden Rule — Every Formula Starts With “=”
Trust me on this — if there is one thing to remember before you touch a formula, it is this: every formula starts with an equals sign. Type 5+3 in a cell and Excel thinks you want to display the text “5+3”. Type =5+3 and Excel calculates it and shows 8.
That equals sign is the magic switch that tells Excel: stop displaying, start calculating. This trips up almost every beginner at least once — when a formula does not seem to work, the first thing to check is whether you forgot the = at the start.
Formula vs. Function — What’s the Difference?
You will hear both words thrown around, so here is the quick version. A formula is the whole expression you type in a cell — the complete instruction starting with =. A function is a named, built-in tool that lives inside a formula. SUM, AVERAGE, COUNT — these are functions.
So =SUM(B2:B6) is a formula. SUM is the function inside it. In practice, most people use the words interchangeably, and that is completely fine. But now you know the difference if anyone asks.
How to Write Formulas in Excel (The Right Way)
Before learning specific functions, it helps to know the mechanics of actually writing and editing formulas. There are two ways to do it, and both work perfectly.
Using the Formula Bar
Look at the top of your spreadsheet, just above the column headers. That long white input box running across the screen is the formula bar. When you click any cell, its full contents appear there — whether it is a number, text, or formula.
How to write a formula using the Formula Bar:
- Click the cell where you want your result to appear.
- Click inside the formula bar at the top of the screen.
- Type your formula, starting with the equals sign
=. - Press Enter to confirm.
Typing Directly Into a Cell
You can also just click a cell and start typing — no formula bar required. Most people work this way once they are comfortable.
How to type a formula directly into a cell:
- Click the cell where you want the result.
- Type
=to start the formula. - Type the rest of your formula.
- Press Enter to confirm, or Tab to confirm and move one cell to the right.
Why You Should Always Use Cell References
Here is one of the most important habits you can build right from day one. When you write a formula, reference the cells that hold your numbers — do not type the numbers directly into the formula.
Think of it like a live link versus a printed copy. If someone’s phone number changes, you want the live link that updates automatically — not a printed copy that stays wrong forever.
In Excel terms: if B2 contains 500 and B3 contains 300, do not write =500+300. Write =B2+B3 instead. Now if B2 changes to 600, your formula automatically shows 900. The hardcoded version stubbornly keeps showing 800. Cell references keep your spreadsheet accurate and alive.
The 5 Basic Formulas in Excel Every Beginner Needs
Here they are — the five formulas that cover the vast majority of everyday spreadsheet work. To keep the examples concrete and consistent, imagine you are tracking your monthly household expenses. Column A has category names (Rent, Groceries, Transport, Utilities, Entertainment) and column B has the dollar amounts.
| Formula | Syntax | What It Does |
|---|---|---|
| SUM | =SUM(range) | Adds all numbers in a range |
| AVERAGE | =AVERAGE(range) | Calculates the mean of a range |
| COUNT | =COUNT(range) | Counts cells containing numbers |
| MIN | =MIN(range) | Returns the smallest value |
| MAX | =MAX(range) | Returns the largest value |
1. The Excel SUM Formula — Add Up Numbers Instantly
SUM is the workhorse of Excel. It adds up a range of numbers and hands you the total. If you only learn one formula, make it this one.
Syntax
=SUM(number1, [number2], …)Real Example
=SUM(B2:B6)Adds all values from cell B2 through B6. The colon means “from here to here.”
In the budget example, typing =SUM(B2:B6) in cell B7 gives you the total monthly spend in one second.
💡 PRO TIP
There is a shortcut for SUM called AutoSum. Select the empty cell directly below a column of numbers and press Alt + = (hold Alt, then press the equals sign). Excel instantly suggests a SUM formula covering all the numbers above. Press Enter to confirm. This is one of the most satisfying shortcuts in all of Excel.
2. The Excel AVERAGE Function — Find the Mean in Seconds
AVERAGE calculates the arithmetic mean of a range. It adds everything up and divides by the count — but you never have to do any of that yourself.
Syntax
=AVERAGE(number1, [number2], …)Real Example
=AVERAGE(B2:B6)Returns the mean expense per category across your monthly budget.
One thing worth knowing: AVERAGE ignores blank cells entirely. If a cell in your range is empty, Excel skips it — it does not treat it as zero. If a cell contains the number 0, however, AVERAGE does include it.
⚠️ COMMON MISTAKE
Including your header row in the range by accident. If your range starts one row too high and picks up a text label like “Amount,” Excel returns a #VALUE! error. Always make sure your range starts at the first actual number, not the column label above it.
3. The Excel COUNT Formula — Count Your Data Entries
COUNT tells you how many cells in a range contain numbers. It sounds almost too simple — until you are working with 300 rows and genuinely need to know how many entries you have.
Syntax
=COUNT(value1, [value2], …)Real Example
=COUNT(B2:B6)Returns 5 — the number of cells in B2:B6 that contain numerical values.
You have probably seen COUNTA alongside COUNT and wondered which to use. Here is the quick answer:
COUNT only counts cells with numbers. COUNTA counts any non-empty cell — numbers, text, dates, anything at all.
So if you want to count the expense categories in column A (text labels, not numbers), you need =COUNTA(A2:A6), not =COUNT(A2:A6). COUNT would return zero because column A holds text. Rule of thumb: COUNT for numbers, COUNTA for anything else.
4. Excel MIN and MAX — Spot Your Lowest and Highest Values
MIN and MAX are a natural pair. MIN returns the smallest number in a range. MAX returns the largest. Together they give you the full picture of the extremes in your data.
Syntax
=MIN(number1, [number2], …)
=MAX(number1, [number2], …)Real Examples
=MIN(B2:B6) → your cheapest expense this month
=MAX(B2:B6) → your most expensive expense this monthYou can use both on the same range without any issues. Many people place them side by side in their spreadsheet to instantly see the spread of their data.
💡 PRO TIP
MIN and MAX work brilliantly for all kinds of real-world data — best and worst sales day, highest and lowest exam score, cheapest and most expensive item in a product list. Any time you need the extremes of a dataset, these two are your fastest path to finding them.
5. Bonus — Combining Formulas With Simple Arithmetic
Once you are comfortable with the basic formulas in Excel, you can start combining them to answer more specific questions. This is where things get genuinely interesting.
Combining Examples
=MAX(B2:B6)-MIN(B2:B6) → gap between highest and lowest
=SUM(B2:B6)-MIN(B2:B6) → total above minimum expenseArithmetic Operators
+ Addition | - Subtraction
* Multiplication | / Division
Excel follows standard order of operations — multiplication and division before addition and subtraction. Use parentheses to override this when needed: =(B2+B3)*2 adds B2 and B3 first, then doubles the result.
Common Beginner Mistakes (And How to Fix Them)
These errors happen to everyone. Knowing them in advance means you will fix them in ten seconds instead of spending twenty minutes confused.
⚠️ COMMON MISTAKE — Forgetting the Equals Sign
You type SUM(B2:B6) and Excel just displays that text back at you. Nothing is calculated.
Fix: Click the cell, press F2 to enter edit mode, go to the start of the entry, and add the = sign. Or just retype the formula from scratch — it takes three seconds.
⚠️ COMMON MISTAKE — Selecting the Wrong Range
If your SUM or AVERAGE is giving you an unexpected number, there is a good chance your range is slightly off — one row too many, one row short, or accidentally including a column you did not mean to.
Fix: Click the cell with the formula. Look at the formula bar — you will see the range highlighted in colour on your spreadsheet. If it is not covering the right cells, click into the formula bar, fix the range reference, and press Enter.
⚠️ COMMON MISTAKE — The #VALUE! and #NAME? Errors
#VALUE! means your formula is trying to do math on a cell that contains text instead of a number. Check your range — one of the included cells probably has a label or word in it.
#NAME? means Excel does not recognise the function name you typed — almost always a typo. Writing AVRAGE instead of AVERAGE, for example. Double-check the spelling of the function name.
Practice Exercise — Try It Yourself
Reading about formulas is a great start. Actually typing them into Excel is what makes them stick.
🧪 TRY IT YOURSELF
Set up your spreadsheet exactly like this:
| Cell | Column A | Column B |
|---|---|---|
| Row 1 | Category | Amount |
| Row 2 | Rent | 1200 |
| Row 3 | Groceries | 350 |
| Row 4 | Transport | 180 |
| Row 5 | Utilities | 90 |
| Row 6 | Entertainment | 140 |
Now try these three tasks:
- In cell B8, use SUM to find your total monthly expenses.
- In cell B9, use AVERAGE to find the mean expense per category.
- In cell B10, use MAX to find your biggest single expense. In B11, use MIN to find the smallest.
Check your answers:
SUM = 1960 | AVERAGE = 392 | MAX = 1200 (Rent) | MIN = 90 (Utilities)
Frequently Asked Questions
What is the most used formula in Excel?
The Excel SUM formula is almost universally considered the most commonly used formula across all skill levels. It is simple, fast, and relevant to virtually any dataset involving numbers. The AutoSum shortcut (Alt + =) makes it even quicker to use in practice.
Can I use formulas on text, not just numbers?
The arithmetic formulas in this lesson — SUM, AVERAGE, MIN, MAX — only work on numbers. However, COUNTA counts any filled cell including text. Excel also has a separate family of text functions (like LEN and CONCATENATE) for working with words and characters. Once you are comfortable with the basics, those are great to explore next.
What happens if I delete a cell that a formula is using?
If you delete the actual cell (not just its contents), any formula referencing it will break and show #REF!. The safest habit is to press the Delete key to clear cell contents rather than removing the cell from the grid. If you do get a #REF! error, click the formula cell and rewrite the range reference manually.
Further Reading
📚 Authoritative Excel Resources
Official Microsoft documentation with full syntax breakdowns and additional examples for every function covered in this lesson.
Clean, beginner-friendly function references that pair perfectly with what you have learned here. Excellent for going a step further once you have the basics locked in.
What to Learn Next
You have covered a lot of ground. You now know the golden rule of formulas, how to write formulas in Excel from scratch, and how to use all five of the most essential beginner functions: SUM, AVERAGE, COUNT, MIN, and MAX.
The best next step is to strengthen your understanding of cell references — specifically the difference between relative and absolute references. That knowledge unlocks a huge amount of what Excel can do. Check out Lesson 4: Cell References in Excel to dig into that.
After that, the IF function is the point where Excel starts feeling like a genuinely smart tool rather than just a calculator. Lesson 6: AutoFill & Flash Fill in Excel builds directly on what you have learned here. Keep going — you are doing great.