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 non blank cells that satisfies one condition.


Related Formulas

Sum cells that contain errors


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