Count cells with #VALUE! error
This tutorial shows how to count the number of cells in a specified range that contain an #VALUE! error using an Excel formula, with the COUNTIF function
|
=COUNTIF(B5:B10, "#VALUE!")
|
GENERIC FORMULA
=COUNTIF(B5:B10, "#VALUE!")
ARGUMENTS EXPLANATION This formula uses the COUNTIF function, with a criteria set to "#VALUE!", to count the number of cells that contain an #VALUE! error in the selected range.
In this example the range from which we are counting the total number of cells that contain an #VALUE! error is B5:B10, which contains a 2 cells with an #VALUE! 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 | |
| Count cells with #DIV/0! error | How to count the number of cells in a specified range that contain an #DIV/0! 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 |