I. Intro
The COUNT function calculates the number of cells with numeric values (non-text numbers, dates) in the specified range. To count cells with text or spaces, use COUNTA function.
II. About the function
- Formula: =COUNT( value1,[value2],...)
- Arguments:
- Value1: The first value or range to count.
- Value2: Optional. Other values or ranges to count.
- Example: =COUNT(A2:A100, B2:B100) counts how many values there are in the A2:A100 and B2:B100 ranges.
III. Steps
Use the function
- Opent the spreadsheet. Select a cell and enter =COUNT(value1, [value2, ...]).
- Press Enter to get the result.
For example, =COUNT(B2:B11) in the image below counts the number of people who took the English exam.
250px|700px|reset
Delete the function
Select the cell with the COUNT function and press Delete.
IV. Use case
Calculate the number of employees working overtime
The COUNT function can be used to calculate the number of employees working overtime.
- Formula used in the figure below: =COUNT(A2:A11)
- About the arguments: The data set below contains a list of employees who have worked overtime. Since the range A2:A11 contains numeric values, the result from COUNT is the number of employees who have worked overtime.
250px|700px|reset