Counting non-blank cells

  • Thread starter Thread starter Kathryn Bittman
  • Start date 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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count of visible, non-blank cells only? 8
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Why doesn't excel count function update automatically? 1
Count from Blank & Non-Blank Cells 2
Counting Blanks 6
how to count non blank cells from another worksheet 1
Count macro 2
Counting cells containing formulas with blank results 3

Back
Top