0404198935

How do I Count all Non Empty cells in google Spreadsheet

 SpreadSheetTips  count cells
To count the number of cells that are not blank, just follow these steps.
  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(A1:A33). Or Begin by typing =COUNTA(  Then modify the cell area with the pre input Selection
  2. Just hit enter, and the COUNTA function will automatically count the cells that are not blank. This will tally the cell count value

 

 

How do I Count all Non Empty cells in google Spreadsheet