This wikiHow teaches you how to display the number of cells in a selected range using Google Sheets for Android.
Steps
-
Open Google Sheets. It's the green icon with a white table inside. It's typically in the app drawer or on the home screen.
-
Tap the spreadsheet.Advertisement
-
Tap an empty cell below those you want to count. This highlights the cell and opens the formula blank at the bottom of the screen.
-
Type =count . A pop-up menu will appear at the top of the formula bar.
-
Tap COUNT . The formula now appears in the bar as =COUNT() .
-
Tap the () after “COUNT.” Now you can select the range of cells you want to count.
-
Tap the first cell in the range. This highlights the cell and surrounds it by a red line.
-
Drag the red line across the range of cells to be counted. This selects the range.
-
Tap. It's to the right of the formula (fx) bar. The number of cells in the selected range now appears in the cell containing the formula.Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
About this article
Thanks to all authors for creating a page that has been read 3,384 times.
Advertisement
