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 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