Count cells with #DIV/0! error
This tutorial shows how to count the number of cells in a specified range that contain an #DIV/0! error using an Excel formula, with the COUNTIF function
|
=COUNTIF(B5:B10, "#DIV0!")
|
GENERIC FORMULA
=COUNTIF(B5:B10, "#DIV0!")
ARGUMENTS EXPLANATION This formula uses the COUNTIF function, with a criteria set to "#DIV0!", to count the number of cells that contain an #DIV0! error in the selected range.
In this example the range from which we are counting the total number of cells that contain an #DIV0! error is B5:B10, which contains a 2 cells with an #DIV0! error (B7 and B9). |
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Count cells with errors | How to count the number of cells in a specified range that contain errors | |
| Count cells with #N/A error | How to count the number of cells in a specified range that contain an #N/A error | |
| Count cells with #NAME? error | How to count the number of cells in a specified range that contain an #NAME? error |
RELATED FUNCTIONS
| Related Functions | Description | Related Functions and Description |
|---|---|---|
| COUNTIF Function | The Excel COUNTIF function returns the number of cells in a range that meet a specified criteria |