How to Count Cells on Google Sheets on Android

This wikiHow teaches you how to display the number of cells in a selected range using Google Sheets for Android.

Steps

  1. Image titled Count Cells on Google Sheets on Android Step 1
    1
    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.
  2. Image titled Count Cells on Google Sheets on Android Step 2
    2
    Tap the spreadsheet.
    Advertisement
  3. Image titled Count Cells on Google Sheets on Android Step 3
    3
    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.
  4. Image titled Count Cells on Google Sheets on Android Step 4
    4
    Type =count. A pop-up menu will appear at the top of the formula bar.
  5. Image titled Count Cells on Google Sheets on Android Step 5
    5
    Tap COUNT. The formula now appears in the bar as =COUNT().
  6. Image titled Count Cells on Google Sheets on Android Step 6
    6
    Tap the () after “COUNT.” Now you can select the range of cells you want to count.
  7. Image titled Count Cells on Google Sheets on Android Step 7
    7
    Tap the first cell in the range. This highlights the cell and surrounds it by a red line.
  8. Image titled Count Cells on Google Sheets on Android Step 8
    8
    Drag the red line across the range of cells to be counted. This selects the range.
  9. Image titled Count Cells on Google Sheets on Android Step 9
    9
    Tap
    Image titled Android7done.png
    .     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

You Might Also Like

Sign Out of Your Google Account on All Devices at Once
How to
Sign Out of Your Google Account on All Devices at Once
Turn Off Google Safesearch
How to
Turn Off Google Safesearch
Fix the "Google Play Store Has Stopped" Error
How to
Fix the "Google Play Store Has Stopped" Error
Write a Review on Google
How to
Write a Review on Google
Search by Image on Google
How to
Search by Image on Google
Buy a Google Play Gift Card Online on Android
How to
Buy a Google Play Gift Card Online on Android
Access Google Assistant
How to
Access Google Assistant
Restore Google Authenticator
How to
Restore Google Authenticator
Make a Google Account Without Gmail
How to
Make a Google Account Without Gmail
Get a Google Voice Phone Number
How to
Get a Google Voice Phone Number
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
How to
Apply a Formula to an Entire Column on Google Sheets on PC or Mac
Create a Google Profile
How to
Create a Google Profile
Use Google Translate
How to
Use Google Translate
Sort by Number on Google Sheets on PC or Mac
How to
Sort by Number on Google Sheets on PC or Mac
Advertisement

About This Article

Nicole Levine, MFA
Written by:
Nicole Levine, MFA
Tech Specialist
This article was written by Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 2,668 times.
How helpful is this?
Co-authors: 3
Updated: May 25, 2021
Views: 2,668
Categories: Google Applications
Advertisement