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

- [Instructor] Three viable functions … that allow us to tabulate data as we're working with it … are COUNT, COUNTA, and COUNTBLANK. … In this worksheet here, I've got a list, … maybe I haven't seen it in awhile. … As I click column A, … the status bar is revealing something that's valuable. … The word Count appears in the status bar … at bottom of the screen, 701 cells have data, … and by the way, if you're not seeing an entry like that, … a right-click within the status bar, … and consider checking all these six entries right here. … at different times as you highlight data, … you'll get totals for Average, Count, Numerical Count, … and so on as we see them here. … So that's going to be valuable, … so I recommend checking all those … if they're not already checked. … So that's valuable information. … We might want to know as this list grows and shrinks, … or maybe it's a dynamic list, … right on the worksheet here, let's keep track of that data, … and here we'll use a function called COUNTA. …