Accountancy Part CSpreadsheet

Which among the following is not a COUNT function in Excel?

Which among the following is not a COUNT function in Excel?

Answer & explanation

Correct answer: option 4

The correct answer is Option (4) → COUNTFOR

Besides COUNT, Excel has three other counting functions: COUNTA (non-blank cells), COUNTBLANK (empty cells) and COUNTIF (cells that meet a given condition). There is no function called COUNTFOR.

Option (1) COUNTIF — A COUNT function in Excel. It counts the cells in a range that meet the given criteria.

Option (2) COUNT BLANK — A COUNT function in Excel. COUNTBLANK counts the empty cells in a range.

Option (3) COUNTA — A COUNT function in Excel. It counts the cells that are not empty.

NCERT (2026-27 edition):
COUNT – “… In Excel other than counting function COUNT; other functions are COUNTA, COUNTBLANK, and COUNTIF — which enable us to count the number of cells that contain values, are nonblank (and thus contain entries of any kind), or count only the cells in a given range that meet the user defined criteria.”