COUNT / COUNTA / COUNTBLANK — Attendance list
Diagnose a messy attendance list (mixed Yes/No, 1/0 and blanks) with COUNT, COUNTA, COUNTBLANK and ISTEXT, then fix the inconsistent entries — 8 guided steps.
=COUNT( range )
1 / 8
How many cells in the Present column contain a numeric value?
=COUNT(C2:C16)
=COUNTA( range )
2 / 8
How many cells in the Present column are filled in (not empty)?
=COUNTA(C2:C16)
=COUNTBLANK( range )
3 / 8
How many people were not checked in at all?
=COUNTBLANK(C2:C16)
= COUNTA(...) - COUNT(...)
4 / 8
How many cells contain text instead of a number? (hint: COUNTA counts everything, COUNT only numbers)
=COUNTA(C2:C16)-COUNT(C2:C16)
=ISTEXT( cell )
5 / 8
The Present column mixes numbers and text. In D2, test whether C2 contains text with the ISTEXT function.
=ISTEXT(C2)
6 / 8
Fill the formula from D2 down for every person. Notice the TRUE/FALSE alternation.
=ISTEXT(C16)
=IF( ISTEXT(...) , IF( ... ) , value )
7 / 8
Write a formula that fixes C2: if it is the text "Yes" → return 1, if it is the text "No" → return 0, otherwise keep the value as is.
=IF(ISTEXT(C2),IF(C2="Yes",1,0),C2)
=IFS( cond1 , result1 , cond2 , result2 , TRUE , default )
8 / 8
Same exercise, but this time with IFS: write a single formula that handles the 3 cases — "Yes" → 1, "No" → 0, otherwise the original value.
=IFS(C3="Yes",1,C3="No",0,TRUE,C3)
Your score is
Restart
