How to Count Cells on Google Sheets on PC or Mac

This wikiHow teaches you how to use the COUNTIF function in Google Sheets to find the number of cells in a range.

Steps

  1. Image titled Count Cells on Google Sheets on PC or Mac Step 1
    1
    Go to https://sheets.google.com in a web browser. If you’re not already signed in to your Google account, follow the on-screen instructions to sign in now.
  2. Image titled Count Cells on Google Sheets on PC or Mac Step 2
    2
    Click the file you want to edit. If you prefer to create a new spreadsheet, click the box with a “+” at the top-left corner of the list.
    Advertisement
  3. Image titled Count Cells on Google Sheets on PC or Mac Step 3
    3
    Double-click the empty cell where you want the count to appear. This is where you’ll enter the formula.
  4. Image titled Count Cells on Google Sheets on PC or Mac Step 4
    4
    Type =COUNTIF( into the cell.
  5. Image titled Count Cells on Google Sheets on PC or Mac Step 5
    5
    Select the cells you want to count. To do this, click and drag the mouse over the entire range. This adds the range to the COUNTIF formula.
    • You can also type the range manually in the following format: B2:C4.
  6. Image titled Count Cells on Google Sheets on PC or Mac Step 6
    6
    Add qualifying criterion after a comma. To count every selected cell regardless of its value, skip this step. Otherwise, type a , and then type the criteria between quotes (""). Here are some examples:[1]
    • To count only the cells in B2:C4 with values over 50, your formula would look like =COUNTIF(B2:C4,">50"
    • To count only the cells in B2:C4 that say “Yes,” your formula would look like =COUNTIF(B2:C4,"Yes".
  7. Image titled Count Cells on Google Sheets on PC or Mac Step 7
    7
    Type ) at the end of the formula. This closes the formula.
    • Example without criterion: =COUNTIF(B2:C4)
    • Example with criterion: =COUNTIF(B2:C4,">50")
  8. Image titled Count Cells on Google Sheets on PC or Mac Step 8
    8
    Press ↵ Enter or ⏎ Return. The count of selected cells that meet the entered criteria (if applicable) now appears in the cell.
    Advertisement

You Might Also Like

Make a Zip File
How to
Make a Zip File
Copy and Paste
How to
Copy and Paste
Automatically Shut Down Your Computer at a Specified Time
How to
Automatically Shut Down Your Computer at a Specified Time
Copy and Paste a Link
How to
Copy and Paste a Link
Open XML
How to
Open XML
Shut Down Your PC with a Shortcut Key
How to
Shut Down Your PC with a Shortcut Key
Shut Down or Restart Another Computer Using CMD
How to
Shut Down or Restart Another Computer Using CMD
Refresh a Page
How to
Refresh a Page
Jitter Click
How to
Jitter Click
Turn Off Driving Mode
How to
Turn Off Driving Mode
Select All
How to
Select All
Open Downloads
How to
Open Downloads
Unzip a File
How to
Unzip a File
Change a File Extension
How to
Change a File Extension
Advertisement

References

  1. ↑ https://support.google.com/docs/answer/3093480?hl=en

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 51,814 times.
How helpful is this?
Co-authors: 3
Updated: March 30, 2019
Views: 51,814
Categories: Basic Computer Skills
Article SummaryX

1. Sign in to Google Sheets.
2. Open a file.
3. Double-click an empty cell.
4. Type =COUNTIF(.
5. Select the cells to count.
6. Add qualifying criteria (optional).
7. Type ).
8. Press ↵ Enter or ⏎ Return.

Did this summary help you?
Advertisement