how to count blank cells in excel
Excel COUNTBLANK Function
- Summary. …
- Count cells that are blank.
- A number representing blank cells.
- =COUNTBLANK (range)
- range – The range in which to count blank cells.
- The COUNTBLANK function returns a count of empty cells in a range. …
- Excel COUNTA Function
How do I count blank and non blank cells in Excel?COUNTA Method
- Select a blank cell and type the =COUNTA function including the range of cells that you want to count. For example, we used =COUNTA(A2:A11).
- Just hit enter, and the COUNTA function will automatically count the cells that are not blank.
- You now have the total number of cells that have values in it!