Count cells that are errors

{=COUNT(IF(ISERROR(CellRange)*1))} = 2
{=COUNT(IF(ISERROR(CellRange),1))} = 2
{=COUNT(IF(ISERROR(CellRange),1,""))} = 2

Refer to Conditional Counting

To count the number of cells that contains a specific error
=COUNTIF(cellrange,"#DIV/0!")

Built-in Functions

COUNTIF - (COUNTIFS) The number of numerical values that satisfies one condition.

Related Formulas

Sum cells that contain errors