Most of the calculations you perform in Google Sheets involve sums and averages. However, there will be times when you need to count the number of cells that contain specific types of values such as numbers, blanks, or unique values.
- Most of the calculations you perform in Google Sheets…will involve sums and averages.…However, there will be times when you need to count…the number of cells that contain…specific types of values.…Those can be numbers, blanks or unique values.…I'll show you how to do that…using several different functions in this movie.…The COUNT function counts the number of numbers…in a data range.…So for example, I'll be counting from B2 through B10…which is a range that consists of nine cells.…
So I'll click in cell B11, type an equal sign…and then type "count"…followed by a left parenthesis…and this returns a count of the number…of numeric values in a data set.…I'll select cells B2 through B10,…type a right parenthesis and enter,…and I see that I have six numbers within that range.…And if I look at cells B2, I have one.…B3 is another.…B4 is a number, don't have any numbers from 5 through 7…and then three more numbers for a total of six.…
The next function I'll use, COUNTA,…counts the number of values in a range.…It counts numbers, it also counts words,…
Author
Curt Frye
Released
1/3/2018LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Entering formulas
- Creating, editing, and deleting named ranges
- Using mathematical functions such as SUM and AVERAGE
- Summarizing data
- Analyzing financial data
- Working with dates and times
- Looking up values
- Multiplying arrays
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome50s
-
-
1. Creating and Managing Formulas
-
Enter and edit a formula3m 42s
-
Show formulas in a worksheet2m 35s
-
-
2. Using Mathematical Functions
-
Round values up or down4m 49s
-
Create random numbers7m 24s
-
Multiply a set of numbers2m 38s
-
Count types of values2m 59s
-
Count values conditionally7m 40s
-
-
3. Summarizing Data Using Statistical Functions
-
Rank values in a range4m 32s
-
4. Analyzing Data Using Financial Functions
-
Determine loan payments2m 34s
-
-
5. Working with Dates and Times in Formulas
-
Find the parts of a date2m 55s
-
Find the parts of a time2m 36s
-
Calculate duration9m 14s
-
-
6. Performing Lookup and Linking Tasks Using Formulas
-
Create a hyperlink in a cell3m 27s
-
7. Summarizing Arrays of Data
-
Multiply two arrays2m 23s
-
Transpose an array1m 10s
-
-
Conclusion
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: Count types of values