### description:

Count non-empty cells in a range. |

### syntax:

=COUNTA( value1, [value2], …) |

### required arguments:

value1 |
The first value. |

### optional arguments:

[value2] |
The second value. |

### example:

The following example counts cells that are not blank (in range A1:E2).
In this range only cells |

### notes:

You have to be careful because any value will be counted, even space. |

### additional examples:

Count cells that are not blank. |

Remove blank rows. |

### related functions:

COUNT |

COUNTIF |

COUNTIFS |

### more resources:

Excel functions |

Excel formulas |

Excel 2013 Formulas |