MoonPoint Support Logo

 

Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used ProductsAmazon Warehouse Deals



Advanced Search
May
Sun Mon Tue Wed Thu Fri Sat
         
29
           
2015
Months
May


Fri, May 29, 2015 9:29 pm

Counting cells that aren't blank in Google Sheets

To count the number of cells containing content, i.e., those that aren't blank, in Google Sheets, which is part of Google Docs and is Google's online equivalent of Microsoft Excel you can use COUNTIF or COUNTA. E.g., suppose you wish to count the number of cells in column A from A2 to A64 which contain data, ignoring any cells that are blank. You could use COUNTIF(A2:A64,"<>"). The "<>", instructs Google Sheets to only count cells that don't have a null value, i.e., ones containing some data. Alternatively, you could use COUNTA(A2:A64). If you wanted the number that were blank, you could use COUNTBLANK(A2:A64).

[/network/web/services/google] permanent link

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo