MIN
Returns the smallest number.
=MIN(B2:B10)
MAX
Returns the largest number.
=MAX(B2:B10)
Example
|
Salesperson |
Sales |
|
Amit |
45000 |
|
Neha |
62000 |
|
Rahul |
38000 |
|
Priya |
75000 |
|
Simran |
55000 |
Minimum Sales
=MIN(B2:B6)
Result: 38000
Maximum Sales
=MAX(B2:B6)
Result: 75000
COUNT
Counts cells containing numbers.
=COUNT(B2:B10)
COUNTA
Counts non-empty cells.
=COUNTA(A2:A10)
COUNTBLANK
Counts empty cells.
=COUNTBLANK(A2:A10)
Important Difference
|
Function |
Counts |
|
COUNT |
Numeric cells |
|
COUNTA |
Non-empty cells |
|
COUNTBLANK |
Empty cells |
Practice
Create an Employee Data sheet containing names, salaries, departments, and some blank cells. Use all three counting functions.