From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more

Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use various Excel count functions: COUNT, COUNTA, COUNTBLANK, and more

“

- [Instructor] Three viable functions that allow us 2 to tabulate data as we're working with it are count, 3 count A and count blank. 4 In this worksheet here, I've got a list, 5 maybe I haven't seen it in a while. 6 As I click column A, 7 the status bar is revealing something that's valuable. 8 The word count appears in the status bar 9 at the bottom of the screen. 10 701 cells have data. 11 And by the way, if you're not seeing an entry like that, 12 a right click within the status bar 13 and consider checking all of these six entries right here. 14 At different times, as you highlight data, 15 you'll get totals for average count, 16 numerical count, and so on as we see them here. 17 So that's going to be viable. 18 So I recommend checking all those 19 if they're not already checked. 20 So that's viable information. 21 We might want to know as this list grows and shrinks, 22 and maybe it's a dynamic list, right on…

Contents