can I make an equation to count how many cells are filled below acertain cell?
 

would like the top cell to automatically tell me how many cells below
it have text.

can I make an equation to count how many cells are filled below acertain cell?
 

On Apr 2, 4:01*pm, V L wrote:
would like the top cell to automatically tell me how many cells below
it have text.

EXCEL 2007

=COUNTA
- will count the number of cells in a range that are not empty.

can I make an equation to count how many cells are filled below acertain cell?
 

On Monday, April 2, 2012 11:01:49 AM UTC-4, V L wrote:
would like the top cell to automatically tell me how many cells below
it have text.

thanks!

can I make an equation to count how many cells are filled below a certain cell?
 

Hi
Not sure if i understand but try this :
=counta(A3:A200)
Adjust the range to your needs.
Cimjet
"V L" wrote in message
...
would like the top cell to automatically tell me how many cells below
it have text.