From the course: Excel 2016: 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.

Using COUNT, COUNTA, and the status bar

Using COUNT, COUNTA, and the status bar

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Using COUNT, COUNTA, and the status bar

“

- Excel has a function called COUNTA. And we're looking at a worksheet called COUNTA. There's a companion function called COUNT. Very similar in nature with one obvious difference. First of all, when you click a column letter, or if you highlight cells, you're likely to see in the status bar at the bottom of the screen, a count and also a numerical count. In Column C, there are 100 cells that have data in them. There are 99 cells that have a number in them. And so, by deduction, of course, you can see we're talking about the differences there's heading in Column C. Now in Column D we've got some blanks there. But as we click Column D look at the bottom of the screen. 93 of those cells have data in them, 91 have numbers. There's a difference of two. Might not be obvious what's going on there. Now, the function called COUNTA actually tabulates the number of cells that have data. For example, =COUNTA and we can look at any column that we choose. For example, Column B. How many of those…

Contents