Selecting and manipulating blank cells

- In this worksheet called, "Blanks,"…we've got different clusters of data.…And in each of these groups,…we've got a different way that we have to…confront the idea of blanks.…Doesn't necessarily mean we've got errors,…but occasionally we've got some problems, some issues.…I'm looking at the data in column B.…Now in this list, and I'll click in column A,…double click the bottom edge,…to show you it goes down to row 742.…I'm interested in how many people…do not have benefits of any kind.…D for dental, M for medical, R for retirement.…

So there is a function called, "COUNTBLANK."…Now, if I'm looking only in column B…and I certainly could do this,…unfortunately this would be counting all the blanks…in the entire column.…Remember there are over a million rows…in Excel worksheets, so this number…is going to be quite large.…However, if I make this be,…"B2:B742"…it's only going to count the blank cells…within that range.…247.…On the other hand, if we wanted…to count the number or entries…that do have data, and keep in mind…