Excel COUNTA Practice Question: Using the attendance table, how many students attended on at least one day?…
The question
Using the attendance table, how many students attended on at least one day? 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: 5
How it works
Explanation: The plus sign works like OR: a row counts when Day 1 is filled or Day 2 is filled.
Syntax: =SUMPRODUCT(--(((B2:B7<>"")+(C2:C7<>""))>0))
Only Chetan was absent both days, so 5 students.
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…
- Attendance is marked P in B2:C7 (two days) and left empty when absent. How many P marks…
- The records start under a header in row 1. Count the customer records in column A…
- 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