Counting in Excel 1

[Scott24x7]

Having an extremely stupid moment.

I have a column, some cells have values, some do not (don't care what the values are). I just want to COUNT (or COUNTIF) at the bottom of the column for all the cells that have some value.

I thought: =COUNTIF(F5:F500,"<>' '") would do it, but it doesn't. Any solution for this?


Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."

 

[SkipVought]

Hi,

Try COUNT() or COUNTA()

...and why at the bottom? A vestige of paper & pencil accounting, IMNSHO.

Why not at the top for all to see and never need to hunt for?

 

[Scott24x7]

Thanks Skip.
At the bottom because this is a one-use data analysis that will be presented in another research paper. I'm only interested in aggregations, and most of those will get "displayed" on a summary page, because there are dozens of columns, which will also have different measures applied. (Like number of occurrences, then % of break down, calculated costs based on other criteria... so each "column" will have more than 1 result and putting them in the header would just look terrible. Plus, as I mention, it's not really where they will get used ultimately).
I forgot all about COUNTA(). I'm so rusty these days.


Best Regards,
Scott
ATS, CDCE, CTIA, CTDC

"Everything should be made as simple as possible, and no simpler."