How do I count non-blank cells in a column?
To count the number of cells that are not blank, just follow these steps.
- Select a blank cell and type the =COUNTA function including the range of cells that you want to count.
- Just hit enter, and the COUNTA function will automatically count the cells that are not blank.
How do you count if a cell is blank?
Use the COUNTBLANK function to count blank cells in a range, where the word blank means empty. For example, COUNTBLANK(A1:A10) will count the number of blank cells in the range A1:A10. Cells that contain text, numbers, errors, etc. are not counted.
How do you count unique values in Excel?
Note: In the above formula: A2:A18 is the column data that you count the unique values based on, B2:B18 is the column that you want to count the unique values, D2 contains the criteria that you count unique based on. 2. Then drag the fill handle down to get the unique values of the corresponding criteria.
When do you ignore blank cells in counta?
When you count cells, sometimes you want to ignore any blank cells because only cells with values are meaningful to you. For example, you want to count the total number of salespeople who made a sale (column D). COUNTA ignores the blank values in D3, D4, D8, and D11, and counts only the cells containing values in column D.
How to count unique values based on multiple criteria?
The formula for counting unique values based on multiple criteria is pretty much similar to the above example, though the criteria are constructed a bit differently: Those who are curious to know the inner mechanics, can find the explanation of the formula’s logic here: Find unique values based on multiple criteria.
When to use the counta function in Excel?
Use the COUNTA function to count only cells in a range that contain values. When you count cells, sometimes you want to ignore any blank cells because only cells with values are meaningful to you. For example, you want to count the total number of salespeople who made a sale (column D).