From the course: Google Sheets: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Count types of values

Count types of values - Google Sheets Tutorial

From the course: Google Sheets: Advanced Formulas and Functions

Start my 1-month free trial

Count types of 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…

Contents