MS Excel: 5 Basic Formulas Every Beginner Should Know (With Examples)

Basic Rules of Excel Formulas:

• Always start with = — Without the = sign, Excel treats it as plain text, not a formula. =SUM(A1:A5) ✅ is a formula, but SUM(A1:A5) ❌ is just text.
• Cell references use column letter + row number — Like A1 (column A, row 1), B5 (column B, row 5), C10 (column C, row 10).
• Colon (:) means a range — A1:A5 means "from cell A1 to A5" — that is, A1, A2, A3, A4, A5.
• Comma (,) separates different arguments — =SUM(A1:A5, B1:B5) means add both ranges together.
• Formulas are not case-sensitive — =SUM and =sum both work the same way.

💡 Pro Tip: You can type formulas directly in a cell, or use the formula bar at the top (the long bar that shows cell content). Click on a cell → Click in the formula bar → Type your formula → Press Enter.

Syntax (How to Write It):

=SUM(range)

range = the cells you want to add together (e.g., A1:A10)

Real Example:

Imagine you have monthly sales data:

Cell	Month	Sales (₹)
A1	January	5,000
A2	February	7,500
A3	March	6,200
A4	April	8,100
A5	May	4,800

To find total sales: Click on an empty cell (say A6) and type:

=SUM(A1:A5)

Press Enter → Result: 31,600

Different Ways to Use SUM:

• =SUM(A1:A5) — Add all cells from A1 to A5 (single range)
• =SUM(A1:A5, C1:C5) — Add two separate ranges together
• =SUM(A1, A3, A5) — Add only specific individual cells
• =SUM(A1:A5, 100) — Add a range plus a number directly

⚡ Shortcut: AutoSum (Fastest Way!)

1. Click on the empty cell just below your numbers (e.g., A6 if your data is A1:A5).
2. Click the "AutoSum" (Σ) button in the Home tab (top-right corner of Editing group) or press Alt + =.
3. Excel will automatically detect the range and create the SUM formula for you. Press Enter to confirm!

⭐ AutoSum is the fastest way to add numbers — try it first before typing formulas manually!

💡 Pro Tip: If your range contains blank cells or text, SUM simply ignores them and only adds the numbers. So =SUM(A1:A10) will work fine even if some cells are empty or have text.

Syntax:

=AVERAGE(range)

Real Example:

A student got these marks in 5 subjects:

Cell	Subject	Marks
B1	Math	85
B2	English	72
B3	Science	90
B4	History	68
B5	Hindi	78

To find average marks:

=AVERAGE(B1:B5)

Press Enter → Result: 78.6 (Total 393 ÷ 5 subjects = 78.6)

Different Ways to Use AVERAGE:

• =AVERAGE(B1:B5) — Average of a single range
• =AVERAGE(B1:B5, D1:D5) — Average of two ranges combined
• =AVERAGE(B1, B3, B5) — Average of specific cells only

⚠️ Common Mistake: AVERAGE ignores blank cells and text, but it DOES count cells with 0 (zero). If a student was absent and you put 0 instead of leaving it blank, the 0 will lower the average. If a student was absent, leave the cell blank — AVERAGE will then skip it.

Syntax:

=COUNT(range)

Real Example:

Imagine a class attendance sheet where marks are entered for students who appeared for the exam:

Cell	Student	Marks
C1	Rahul	85
C2	Priya	72
C3	Amit	(blank — absent)
C4	Sneha	90
C5	Vikram	68

To count how many students actually appeared (have marks):

=COUNT(C1:C5)

Press Enter → Result: 4 (because 4 cells have numbers; the blank cell is ignored)

Important: COUNT vs COUNTA — Know the Difference!

• =COUNT(range) — Counts only cells with NUMBERS. Ignores text, blanks, and errors.
• =COUNTA(range) — Counts cells with ANY content (numbers + text + dates + errors). Only ignores truly blank cells. Use this when you want to count text entries like names!
• =COUNTBLANK(range) — Counts only EMPTY/BLANK cells. Useful to see how many entries are missing.

Example: In the table above, =COUNTA(C1:C5) would also give 4 (since blank is still blank). But if C3 had text "Absent" instead of being blank, COUNT would give 3 (only numbers), while COUNTA would give 5 (all non-empty).

Syntax:

=MAX(range)

Real Example:

Using the same marks data: 85, 72, 90, 68, 78

=MAX(B1:B5)

Press Enter → Result: 90 (Science has the highest marks)

More Examples:

• =MAX(A1:A12) — Find the highest monthly sales in a year
• =MAX(C1:C50) — Find the highest salary among 50 employees
• =MAX(D1:D30) — Find the maximum temperature in a month

💡 Pro Tip: MAX ignores blank cells and text — it only looks at numbers. If all cells in the range are blank or text, MAX returns 0.

Syntax:

=MIN(range)

Real Example:

Using the same marks data: 85, 72, 90, 68, 78

=MIN(B1:B5)

Press Enter → Result: 68 (History has the lowest marks)

Combining MAX and MIN — Find the Range:

Want to know the spread/difference between highest and lowest values?

=MAX(B1:B5) - MIN(B1:B5)

Result: 90 - 68 = 22 (The marks range from 68 to 90, a spread of 22 marks)

	A	B
1	Subject	Marks
2	Math	85
3	English	72
4	Science	90
5	History	68
6	Hindi	78

Now Apply All 5 Formulas:

What You Want	Formula	Result
Total Marks	=SUM(B2:B6)	393
Average Marks	=AVERAGE(B2:B6)	78.6
No. of Subjects	=COUNT(B2:B6)	5
Highest Marks	=MAX(B2:B6)	90
Lowest Marks	=MIN(B2:B6)	68

1. Click on the cell where you want the result to appear (the "output cell").
2. Type the equal sign = — this tells Excel you're starting a formula.
3. Type the formula name (like SUM, AVERAGE, COUNT, MAX, MIN).
4. Type an opening parenthesis (.
5. Select the range by either:
   • Typing the cell range manually (e.g., A1:A10)
   • OR using your mouse to click and drag across the cells — Excel will fill in the range automatically!
6. Type a closing parenthesis ).
7. Press Enter — the result will appear in the cell!

💡 Pro Tip: Instead of typing cell references manually, use your mouse to select the range after typing the opening parenthesis. Click on the first cell → Drag to the last cell → Excel automatically fills in the range. This is faster and reduces typing mistakes!

• Forgetting the = sign: Typing SUM(A1:A5) without = will show it as text, not calculate. Always start with =!
• Wrong range selection: =SUM(A1:A4) when you meant =SUM(A1:A5). Double-check that your range includes all the cells you want.
• Missing closing parenthesis: =SUM(A1:A5 — Excel will show an error. Every opening ( must have a matching closing ).
• Spaces in formula: =SUM (A1:A5) with a space before parenthesis — Excel doesn't accept spaces between formula name and parenthesis.
• Using numbers stored as text: If a cell has "50" (with apostrophe or as text), formulas will ignore it. Numbers should be stored as numbers, not text. Check for green triangles in the cell corner — that's Excel warning you!
• Editing a formula by clicking the cell: If you click a cell with a formula, you'll see the formula in the formula bar. To edit it, click in the formula bar or press F2 — don't just start typing, or you'll replace the formula!

Formula	What It Does	Example	Result
=SUM	Adds all numbers	=SUM(10,20,30)	60
=AVERAGE	Mean of numbers	=AVERAGE(10,20,30)	20
=COUNT	Counts numeric cells	=COUNT(10,"A",30)	2
=MAX	Largest number	=MAX(10,20,30)	30
=MIN	Smallest number	=MIN(10,20,30)	10

6. IF — Make Decisions Based on Conditions

=IF(condition, value_if_true, value_if_false)

Example: =IF(B2>=35, "PASS", "FAIL") — If marks in B2 are 35 or above, show "PASS", otherwise show "FAIL". This is extremely useful for grading, eligibility, and status checks!

7. COUNTIF — Count Cells That Meet a Condition

=COUNTIF(range, condition)

Example: =COUNTIF(B2:B50, ">80") — Counts how many students scored above 80. =COUNTIF(A1:A100, "Yes") — Counts how many cells contain "Yes".

8. SUMIF — Add Numbers That Meet a Condition

=SUMIF(range, condition, sum_range)

Example: =SUMIF(A1:A50, "Electronics", B1:B50) — Adds up all sales in column B where column A says "Electronics". Great for category-wise totals!

Q: What does #VALUE! error mean?
A: It usually means you're trying to do math on cells that contain text instead of numbers. Check if your cells have numbers stored as text (look for green triangle in cell corner). Fix: Select the cells → Data → Text to Columns → Finish.

Q: What does #NAME? error mean?
A: Excel doesn't recognize the formula name — you probably misspelled it. Check for typos: SUMM instead of SUM, or AVERG instead of AVERAGE.

Q: What does #REF! error mean?
A: The formula refers to a cell that no longer exists — probably because you deleted a row or column that was part of the formula. Undo (Ctrl+Z) immediately to fix it!

Q: Can I use these formulas across different sheets?
A: Yes! Use the sheet name before the cell reference: =SUM(Sheet2!A1:A10) adds cells from Sheet2. The ! (exclamation mark) separates the sheet name from the cell reference.

Q: How do I copy a formula to multiple cells?
A: Click on the cell with the formula → A small green square (fill handle) appears at the bottom-right corner → Click and drag it down to copy the formula to other cells. Excel automatically adjusts cell references! This is called "AutoFill".

🏷️ Tags:
#MSExcel #ExcelFormulas #ExcelTutorial #SUM #AVERAGE #COUNT #MAX #MIN #ExcelBeginner #LearnExcel #ExcelTips #Spreadsheet #ExcelGuide #BasicFormulas #AutoSum #MicrosoftExcel #ExcelForBeginners #ExcelTraining #DataAnalysis #OfficeTutorial #MSOffice #ExcelFunctions #ReportCard #EduOrbit #ComputerTips #TechTips #Excel2019 #Excel2021 #Excel365 #OfficeSkills