Counting non-blank cells

  • Thread starter Kathryn Bittman
  • Start date
K

Kathryn Bittman

I need a simple formula to count non-blank cells. The
cell data is numerical and I need to exclude the header
row.

I am doing a SUM function for 1 part of my information
(total hours for category), but now need to how many
entries per category.

Any help would be greatly appreciated!
 
R

Ron Rosenfeld

I need a simple formula to count non-blank cells. The
cell data is numerical and I need to exclude the header
row.

I am doing a SUM function for 1 part of my information
(total hours for category), but now need to how many
entries per category.

Any help would be greatly appreciated!
Click to expand...

Do you want to count non-blank cells? Or do you want to count numbers?

If the latter, then COUNT(rng) will do.

If the former, then COUNTA(rng) will do.

See HELP for further info.


--ron
 
Top