Loading…
Loading…
A survey with gaps and stray text is perfect for practising COUNT (numbers only) and COUNTIF (numbers that meet a condition). Remember that text such as "n/a" is not a number.
Syntax
COUNT(range) · COUNTIF(range, criteria)
Read the lesson, then try it yourself in a live spreadsheet.