Using COUNT, COUNTA, and the status bar

- Excel has two similarly named functions.…One called Count and one called Count A.…Count is designed to count the number of cells…that have numerical entries, or numbers.…So, for example,…if we're looking at column D here…we see there's an empty cell,…there's one with some text in it,…here's some text up here as well, too.…Let's just do a quick count to see how many cells…in column D have numbers.…=count, left parentheses for looking in the…entire column D, and we press return,…and we see that 92 cells have numbers.…

At other times it might be valuable to know…how many cells actually have data.…We see at least two more cells here that have data.…And since the list is relatively short…I'll zip through it kind of quickly here,…so about a hundred entries.…There are two additional cells that have data…in addition to numbers.…So the function called Count A,…when applied to that same column D,…is going to give us a different answer.…94 of the cells actually have data.…Now at the bottom of the screen,…in the status bar,…