Excel COUNTA Practice Question: Attendance is marked P in B2:C7 (two days) and left empty when absent. How…
The question
Attendance is marked P in B2:C7 (two days) and left empty when absent. How many P marks are there in total? Put it in E2.
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Student | Day 1 | Day 2 | Result | |
| 2 | Anil | P | P | ? | |
| 3 | Bina | P | |||
| 4 | Chetan | ||||
| 5 | Dev | P | P | ||
| 6 | Esha | P | |||
| 7 | Farah | P |
The yellow cell is where your answer goes.
Show answer
Answer in E2: 7
How it works
Explanation: COUNTA works on a block of cells.
Syntax: =COUNTA(B2:C7)
Day 1 has 4 marks and Day 2 has 3, so 7.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →COUNTA syntax
=COUNTA(value1, [value2], ...)
Counts how many cells in a range are not empty. COUNTA is used in data analysis work to summarize or test patterns across a data set. Full COUNTA guide.
More COUNTA practice questions
- Customer names are in A2:A9 (some rows are empty). How many names are listed? Put it in…
- Using the same table, how many customers already have a status in B2:B9? Put it in D2.
- Quantities are in B2:B9. Some cells hold the text n/a and some are empty. How many cells…
- Using the customer table, find the share of rows that have a name (A2:A9), as a decimal…
- The records start under a header in row 1. Count the customer records in column A…
- Using the attendance table, how many students attended on at least one day? Put it in E2.
- Using the customer table, how many rows have a name in column A but no status in column…
All practice questions · Excel exercises · Interview prep · Cheat sheet