Can I count non-blanks in a range?

[Yerdon]

Hi,

I have a large Excel spreadsheet with 50,000+ rows. At the bottom of each column, I would like to put the number of cells in that column that were not blank.

Can't seem to figure out what kind of function to use...

Any ideas? Thanks!

Joseph

 

[SkipVought]

Hi,

"At the bottom of each column..."

WHY? WHY? WHY?

Why make the user HUNT, SEARCH, SCROLL, SCROLL, SCROLL to find the most important thing on the sheet??? The aggregations at the bottom, is a vestage of ledger books, adding machine and pencil. In an electronic spreadsheet, you can put the aggregations ANYWHERE that makes sense; and certainly, the bottom is not at the top of my list.

Check out the COUNTA function.

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]