# Discussion on: Office challenge: How quickly can you count the number of cells in a selection?

7

### Join the conversation!

View:
Show:
cfeliz 28th Dec 2011
In Excel 2010, you first make your selection and on the bottom left hand side of the screen it will read "Count: ##". Note: It will only count the cells that have information in them.
###### all versions but....
damiross@... 28th Dec 2011
You can see the count of all active cells in a selection in the lower right corner. In versions 2003 and earlier, the default number shown is the sum. Clicking on this number gives you the opportunity to change it from sum to count.
###### this only works on a range with all cells populated with some kind of data
zimmerwoman Updated - 4th Jan 2012
Excel only gives an accurate count on a range with all cells populated with some kind of data. I populated data into a 7-row, 5 column range, skipping cells and using 1-up numbering so I would have the count of populated cells by default - giving me 12 populated cells. Also, the arithmetic progression of integers 1 - 12 equals 78 and that is the sum of the numbers.

The count Excel read was 12, the final number of the 1-up data.

Then I populated the blank cells with "0" by doing a "paste special, add" to the whole range (something we learned in December 2010, if I am not mistaken). Excel now takes those cells into the count, which is now 35 (7 rows X 5 columns). The sum remains the arithmetic progression of 1 through 12, 78 because all the new values added were "0",
###### different method
nicefred60@... 2nd Jan 2012
Count works for cells with data in them but if cells blank count isnt accura
Reselect the area and keep mouse button depressed.
Name Box gives number of rows x number of columns just multiple those numbers
###### query
sk.tomar@... 10th Jan 2012
what about when multiple ranges are selected?
###### not as simple, but still easy peezy.
zimmerwoman Updated - 10th Jan 2012
Copy a space into the clipboard. Select the ranges, "Go To" (F5), Special, Blanks: Paste Special, OK. Look at the status bar. If you have it set up to show the count, Presto-Chango, Magic!!! There it is! The number of blank cells. "CTL Z" to get rid of the spaces.
###### Yup, Name Box
Zahra B. 5th Jan 2012
That would be my first choice also, assuming you can do simple arithmetic (or just get the calculator windows application out to do the multiplication).
Keyboard Shortcuts:
Prev
Next
Toggle
###### Join the conversation
Formatting +
BB Codes - Note: HTML is not supported in forums
• [b] Bold [/b]
• [i] Italic [/i]
• [u] Underline [/u]
• [s] Strikethrough [/s]
• [q] "Quote" [/q]
• [ol][*] 1. Ordered List [/ol]
• [ul][*] · Unordered List [/ul]
• [pre] Preformat [/pre]
• [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.