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

Built-in Functions

COUNTIF - (COUNTIFS) The number of numerical values in a list, table or cell range that satisfies one condition.

Related Formulas

Sum cells that contain errors

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top