Search for a specific value in cells in Excel 2010





Posted By quikStarts
List ViewGrid View

This guide is part of the Microsoft Excel 2010 series

1. Add a print button to the tool bar in excel 2010
2. Create a bar graph in Excel 2010
3. How to add a background image to excel 2010
4. How to add a column to a spreadsheet in excel 2010
5. How to add a URL to Excel 2010
6. How to adjust the print layout in Excel 2010
7. How to auto fit column width in excel 2010
8. How to convert a column into a row in Excel 2010
9. How to convert excel 2010 to PDF
10. How to create a dashboard in Excel 2010




Make: excel

Model / Product: Excel

Version: 2010

Objective / Info: Identify the total number of times a specific value appears in the cells of an Excel 2010 spreadsheet.


1
Open excel by clicking the icon on the desktop or start menu.

2
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.

3
Pick a cell where you want the total to display and double click it.

4
Type "=count" and a smaller menu with a few options will show. Double click "COUNTIF" from the menu.
5
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.

6
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.

  Note : Encore is the value used in this example.

7
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 : excel

Ask a question or provide an answer

Posted Q&A(0)


Name
Email
URL
Comment