COUNT Function - Free Excel Practice Online

This free, interactive exercise teaches you COUNT Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the COUNT Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising COUNT Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this COUNT Function lesson

1. The COUNT function counts all the cells that contain numbers in a specified range of cells. Try typing =COUNT(A2:E2) to get a result of 4!Why? Because exactly 4 cells in the range A2 through E2 contain numbers. The COUNT function is counting them, not summing them.Type the formula below. Remember to start the formula with an equals sign = and to enclose the function inputs in opening and closing parentheses ( ). - The formula =COUNT(A2:E2) would return 4 because there are 4 cells within the range A2:E2 which contain numbers.
2. COUNT only counts the cells that contain numbers, while ignoring blank cells and cells that contain text.What would =COUNT(A1:A5) return? Write the result below (not the formula itself). - The question asks what the formula =COUNT(A1:A5) would return. Because 3 cells in the range A1:A5 contain numbers, the formula would return an answer of 3.
3. Write a COUNT formula that counts how many students have at least one pet.In other words, write a formula to count the cells that contain numbers in column B. - We want to find the number of cells in column B which contain numbers, because this is the number of students that have at least one pet. The formula =COUNT(B2:B8) would count the number of cells in column B that contain a number.
4. The following table contains Q1 sales. Write a COUNT formula to count how many sales people made at least one sale in January.In other words, your formula should count how many cells in column B contain numbers. - We want to find the number of salespeople who made at least one sale in January, so we want the number of cells which contain a number in column B. The formula =COUNT(B2:B5) would tell us how many salespeople made at least one sale in January.
5. Write a COUNT formula that would count the number of months that Chuck made a sale in Q1 (January through March).Your formula should count the number of cells, from B4 through D4, that contain numbers. - We want the number of months that Chuck made at least one sale in Q1 (January through March). Chuck's sales are shown in row 4. To find the number of cells with at least one sale in row 4, we would use the formula =COUNT(B4:D4).
6. Management must calculate a monthly bonus each time an employee makes at least one sale during a given month. Write a COUNT formula to determine how many monthly bonuses must be calculated for Q1.Your formula should count the number of cells in the range B2 through D5 that contain numbers. - We just want to know how many numbers appear in the table, for any employee and any month. We can get that number with the formula =COUNT(B2:D5) (note that something like =COUNT(B:D) could also work).
7. What would =COUNT(A:B) return? How many cells in the range contain numbers (not text or blanks)?Hint: The range A:B contains all cells in columns A and B. - We want to know what answer the formula =COUNT(A:B) would return to us. If we count the cells which contain numbers in the specified range A:B (columns A and B) we would get an answer of 6!
8. Write a COUNT formula that counts how many students have been absent at least one day. - We want the number of students who have been absent at least one day, so we want to count the number of cells in column B which contain numbers. We can get this answer with the formula =COUNT(B:B).
9. True or false: COUNT ignores text values, and only counts the cells that contain numbers. - This is true. COUNT does not count cells with text; it only counts the number of cells within a range which contain numbers!
10. What would =COUNT(A:B) return? - We want to know what answer the formula =COUNT(A:B) would return. The formula is counting the number of cells in the range A:B (columns A and B) which contain NUMBERS. We see that only 5 of the cells contain numbers, so the formula would return an answer of 5.

COUNT Function practice - FAQ