Counting-type formula

  • Thread starter Thread starter Kristen
  • Start date Start date
K

Kristen

Is there a formula that makes a cell state a number that correlates to the
number of cells in selected area that have data entered into them?

I hope this makes sense, I'm having trouble articulating what I mean...

Thank you in advance for any help!
 
So you want to get a count of cells with values in a range.

=COUNTA(A:A) will give all cells in column A that have values.

=COUNT(A:A) will count only cells that are numeric.
 
Back
Top