Practice COUNT & COUNTA Function Online In Excel
Watch: How to use COUNT & COUNTA Function in Excel?
What is COUNT Function?
The COUNT function in Excel counts the number of cells in a range that contain numbers Click here to Read full Tutorial
What is COUNT Function Syntax?
=COUNT(value1,[value2],...)
Practice 1: COUNT Online Practice Excel
Click on any cell below to start practicing Count Function. Check Instruction how to use the Count Function.
- Go to cell F3.
- Type
=COUNT((without quotes). - Select the values you want to count (for example, the “Sales Volume” column).
- Press Enter.
- You will see the total count of numbers in that range
What is COUNTA Function?
The COUNTA function in Excel counts the number of cells in a range that contain any type of data, including empty text and error values Click here to Read full Tutorial
What is COUNTA Function Syntax?
=COUNTA(value1, [value2], ...)
Practice 2: COUNTA Online Practice Excel
Click on any cell below to start practicing Counta Function. Check Instruction how to use the Counta Function.
- Go to cell F7.
- Type
=COUNTA((without quotes). - Select the values you want to count (for example, the “Sales Volume & Country column).
- Press Enter.
- You will see the total count of numbers in that range
Practice 3: DCOUNTA Online Practice Excel
Click on any cell below to start practicing DCounta Function. Check Instruction how to use the DCounta Function.
- Range ($A$1:$C$49): Database where data is stored.
- Absolute Reference:
$keeps the range fixed. - Field (“Country”): The column to check, found in row 1.
- Criteria (E14:E15): Filters data based on conditions.
- DCOUNTA: Counts matching, non-empty records.
