how to count blank cells in excel

how to count blank cells in excel

Excel COUNTBLANK Function
  1. Summary. …
  2. Count cells that are blank.
  3. A number representing blank cells.
  4. =COUNTBLANK (range)
  5. range – The range in which to count blank cells.
  6. The COUNTBLANK function returns a count of empty cells in a range. …
  7. Excel COUNTA Function
    How do I count blank and non blank cells in Excel?
    COUNTA Method
    1. 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).
    2. Just hit enter, and the COUNTA function will automatically count the cells that are not blank.
    3. You now have the total number of cells that have values in it!

Leave a Comment

Your email address will not be published. Required fields are marked *