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