Search for a value in a google doc spreadsheet cell





Posted By quikStarts
List ViewGrid View

This guide is part of the Google Docs series

1. Auto fit column width in Google docs spreadsheets
2. Change a date in a Google doc spreadsheet cell
3. Change the hyperlink color in a docs document
4. Change the slide speed in Google Docs presentation
5. Convert Google docs spreadsheet into a PDF file
6. Convert Google docs spreadsheet into an Excel file
7. Freeze top row when scrolling in Google Docs
8. How to add a column to a google docs spreadsheet
9. How to add a URL to a Google doc document
10. How to add a URL to a Google doc spreadsheet




Make: Google

Model / Product: Docs

Version: Spreadsheet

Objective / Info: Identify the total number of times a specific value appears in the cells of a Google Docs spreadsheet document.


1
Launch Google Docs spreadsheet by visiting google.com, click the "more" menu otpion and select "Documents"
2
Select "spreadsheet" from the menu.
  Note : If you have an existing spreadsheet, open it instead.

3
Populated row one in column A with a title, we are using "Names". Then populate the cells in column A with different values but make sure a least one of the values is repeated.
4
Pick a cell where you want the total to display and double click it.

5
Type "=count" and a smaller menu with a few options will show. Click "COUNTIF(range,criteria)" from the menu.

  Note : Double click "COUNTIF" on the smaller menu if necessary.

6
Click and drag to select the cells that you want to search for values.

  Note : After the cells have been the selected, the range should populate in the cell.

7
Type a comma behind the cell range, followed by an opening quote, followed by the value you want to search for, then a closing quote and press the ENTER key.

8
You should now see a number that represents the number of times the value appears.

  Note : This task should be complete.

|






comments powered by Disqus

Tag : spreadsheet

Ask a question or provide an answer

Posted Q&A(0)


Name
Email
URL
Comment