76
If you want to count cells with content in Excel, you don’t have to do this laboriously by hand. You can use simple formulas to quickly find out the number of filled cells.
How to count cells with content in Excel
If you want to count the number of cells with any content (both numbers and letters) in Excel, select the following function:
- Select an empty cell in the table where you want the result to appear later.
- Enter this formula: =COUNT2(value1:value2)
- Adjust the formula for the range to be counted. For example, if you want to count the cells with content from A1 to A50, enter =COUNT2(A1:A50).
- The formula counts all non-empty cells in the specified range, regardless of whether they contain text, a number, a date, or a formula.
- The formula does not distinguish between different types of content.
- You can use this formula if you want to know how many entries there are in total. These could be mixed lists with names and phone numbers, for example.
- In English, use the formula COUNTA instead of COUNT2.
