Home Courses Microsoft Excel Day 10: MIN, MAX, COUNT and COUNTA
WEEK 2 DAY 10 OF 30 60 MINUTES WORKBOOKS INCLUDED

Day 10: MIN, MAX, COUNT and COUNTA

Statistical insights made simple: find highest & lowest scores and audit datasets with COUNT and COUNTA.

Easy-Learn Framework

Mastering Day 10: What, Why & How

Memory Rule Included
Day 10: MIN, MAX, COUNT and COUNTA Visual Diagram
? WHAT Is It?

Core statistical discovery functions: =MAX() finds the highest number, =MIN() finds the lowest, =COUNT() counts cells with numbers, and =COUNTA() counts all non-empty cells (numbers + words).

! WHY Does It Matter?

Quickly answers managerial questions in large datasets: 'What was our best sale today?', 'What is our cheapest product?', or 'How many candidates showed up for the interview?' without manual searching.

⚙ HOW Does It Work?
Step 1 Find highest: =MAX(C2:C50) returns the peak value in that column.
Step 2 Find lowest: =MIN(C2:C50) returns the smallest value.
Step 3 Count records: Use =COUNT() for purely numeric columns; use =COUNTA() (Count All) to count names or text entries.
Memory Hook & Golden Rule (Remember This Forever):

"COUNT is picky — it only counts numbers! COUNTA has an 'A' for 'All' — it counts any cell that is not blank."

Learning Objectives

What You Will Master Today

  • =MAX(range) to determine top sales, highest marks, or peak temperature
  • =MIN(range) to find lowest expense, minimum discount, or baseline pricing
  • =COUNT(range) counts ONLY cells containing numeric numbers
  • =COUNTA(range) counts ALL non-blank cells (numbers, text, symbols, dates)
Important Keyboard Shortcuts:
=MIN() (Lowest Value)=MAX() (Highest Value)=COUNT() (Count Numbers)=COUNTA() (Count Non-Empty)
Guided Tutorial

Step-by-Step Practical Walkthrough

Step 1

Use '=MAX(C5:C20)' to extract the maximum number from a series.

Step 2

Use '=MIN(C5:C20)' to extract the minimum number.

Step 3

Use '=COUNT(B5:B20)' to count how many records have numerical entries.

Step 4

Use '=COUNTA(A5:A20)' to count total active student or employee names.

Solved Classroom Example

Haldwani Kumaon Motors - Sales Executive Performance Audit

Pre-filled Data & Answers

Study the completed reference worksheet below. Every column illustrates the standard formatting, formula structure, and alignment applied by professional office operators.

Executive NameBranchCars Sold (Units)Revenue Generated (₹)Commission Earned (₹)
Vikram MehraHaldwani Main1411200000168000
Pooja BishtRudrapur Showroom1814400000216000
Deepak JoshiHaldwani Main97200000108000
Neha RawatKathgodam129600000144000
Karan AryaRudrapur Showroom1512000000180000
Download Solved Sample Sheet Includes complete working formula cells, proper currency symbols, and clean borders.
Download Solved Sheet (.xlsx)
Student Assignment

College Admission Application Registry Audit

Your Turn to Practice
Exercise Tasks Checklist:
  • Task 1: Calculate Total Applicants using '=COUNTA(A5:A9)'.
  • Task 2: Calculate Total Entrance Scores submitted using '=COUNT(D5:D9)'.
  • Task 3: Find Highest 12th Board % using '=MAX(C5:C9)' and Lowest using '=MIN(C5:C9)'.
  • Task 4: Find Highest Entrance Score using '=MAX(D5:D9)'.

Exercise Data Template Preview: Download the .xlsx file below and execute each task independently.

App Form NoApplicant Name12th Board %Entrance Exam ScoreFee Paid (₹)
APP-201Aman Tiwari84.5142₹1,000.00
APP-202Bhumika Pandey92.0168₹1,000.00
APP-203Chandan Singh76.2₹1,000.00
APP-204Deepika Arya88.4155
APP-205Gaurav Joshi95.8182₹1,000.00
Download Practice Exercise Sheet Pre-structured practice workbook with raw datasets ready for hands-on classroom lab solving.
Download Practice Sheet (.xlsx)
Mentor Pro Tip from Haldwani Classroom Lab:

If a cell appears blank but '=COUNTBLANK()' doesn't count it, it probably contains an invisible space bar character. Use '=COUNTA()' to catch rogue spaces!

Day 9: SUM and AVERAGE Functi... All 30 Topics Day 11: Relative Cell Referenc...

Need 1-on-1 Guidance on Day 10?

Join our hands-on classroom lab sessions at Digital Skills Academy in Haldwani. Every student receives a dedicated PC workstation, live instructor reviews, and interview prep.