Count the empty cells in Excel.Q. I'm I'm Contraction of I am. Our Living Language Speakers of some scattered varieties of American English sometimes use I'm instead of I've or I have in present perfect constructions, as in puzzled puz·zle v. puz·zled, puz·zling, puz·zles v.tr. 1. To baffle or confuse mentally by presenting or being a difficult problem or matter. 2. , I use the COUNT function to determine how many cells in a worksheet contain numbers and the COUNTA function to tally the empty cells. But when I compare the two results to double-check my answer, it never comes out right. It's like there are phantom cells. Is this an Excel A full-featured spreadsheet for Windows and the Macintosh from Microsoft. It can link many spreadsheets for consolidation and provides a wide variety of business graphics and charts for creating presentation materials. bug? A. I'm afraid you've missed some subtleties of Excel's COUNT function. You're obviously unaware that Excel is counting cells with zero values as empty. You can change the program's default, though, so it doesn't do that. Here's how: Go to Tools, Options, View and uncheck Zero values on the bottom of the Options screen (see screenshot See screen shot. at right). |
|
||||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion