From the course: Excel Formulas and Functions Quick Tips

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Count cells that contain numbers with COUNT

Count cells that contain numbers with COUNT - Microsoft Excel Tutorial

From the course: Excel Formulas and Functions Quick Tips

Start my 1-month free trial Buy for my team

Count cells that contain numbers with COUNT

“

- [Instructor] The COUNT function counts the number of cells within a range that contain numbers. Use this function when the values of those numbers are not what's important. Let's look at this column. Let's find out how many of these products sold at least something in 2021. (mouse clicks) I'll select my range, and close the parentheses. The number that's returned is only counting numbers in this range, including dates and times. Blank cells and cells containing non-numerical values are ignored. Let's expand the range. (mouse clicks) I'll select the first range. This time, I'll include a comma and include a second range. Close the parentheses, hit Enter, and now, both ranges are included in the count.

Contents