Join Curt Frye for an in-depth discussion in this video Creating formulas to count cells, part of Excel for Mac 2016 Essential Training.
- Sometimes, rather than finding the sum,…or average of values in a range of cells,…you'll just want to know how many cells…in that range contain a number,…any value at all, or are blank.…Excel has a number of functions…that count the number of cells in a range…that contain a particular type of data.…I have a data set that lists the percentage…of guests who made contact with…the front desk during a particular day.…You can see that data over here on the left.…I'll use three functions, count, count A, and count blank,…to determine the number of cells in that range…that contain the number, that contain any value,…or that are blank.…
The first function is count, and if I type equal, count,…then a left parentheses, and I select cells B two…through B ten, to add them to the formula,…type a right parentheses and press enter,…I see the number six.…That means that there are six cells…that contain a number.…And if we go over and take a look,…we can see that April one, April two,…and April three, that's three.…Not a number, not a number, not a number,…
Author
Curt Frye
Updated
2/18/2016Released
8/7/2015- Customizing the Ribbon
- Formatting worksheets, cells, and cell data
- Sorting and filtering data
- Working with formulas
- Detecting formula errors
- Creating charts
- Importing data
- Inserting objects and graphics
- Using PivotTables
- Recording macros
- Sharing workbooks
Skill Level Beginner
Duration
Views
Q: This course was updated on 02/18/2016. What changed?
A: We updated one tutorial, "Managing objects using the Selection pane." The new Selection pane, released in a January 2016 Office update, allows Excel for Mac users to more easily rearrange worksheet and slideshow objects.
-
Introduction
-
Welcome59s
-
-
1. Getting Started with Excel
-
Getting help in Excel3m 11s
-
2. Managing Workbooks
-
Setting workbook properties2m 45s
-
3. Working with Worksheets, Cells, and Cell Data
-
Creating named ranges5m 58s
-
Creating an Excel table5m 9s
-
4. Sorting, Filtering, and Managing Worksheets
-
Sorting worksheet data3m 6s
-
Creating a custom sort order4m 49s
-
Filtering worksheet data3m 55s
-
Managing worksheets5m 4s
-
-
5. Summarizing Data Using Formulas and Functions
-
Adding a formula to a cell3m 56s
-
6. Analyzing Data and Formulas
-
Rounding cell values4m 14s
-
Managing scenarios7m 1s
-
7. Formatting Worksheet Elements
-
Managing text alignment4m 46s
-
Copying cell formats3m 29s
-
Managing cell styles4m 10s
-
Managing Office themes5m 45s
-
8. Working with Charts
-
Creating pie charts2m 25s
-
Creating line charts3m 11s
-
Creating XY (scatter) charts2m 38s
-
Creating stock charts2m 42s
-
Adding trendlines to charts3m 31s
-
Creating sparkline charts4m 17s
-
9. Working with External Data
-
Using hyperlinks4m 18s
-
10. Working with Objects
-
Adding and adjusting images4m 58s
-
Manipulating text boxes3m 20s
-
Creating SmartArt graphics4m 19s
-
Creating WordArt2m 55s
-
11. Exploring PivotTables
-
Applying a PivotTable style2m 26s
-
12. Reviewing and Sharing Your Spreadsheets
-
Checking spelling2m 55s
-
Managing workbook comments3m 29s
-
Exporting to other formats2m 48s
-
Protecting a workbook3m 23s
-
-
13. Automating Workbooks Using Macros
-
Running an existing macro4m 31s
-
Recording a macro2m 46s
-
Adding comments to a macro2m 23s
-
-
Conclusion
-
Next steps1m 8s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating formulas to count cells