View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cimjet[_3_] Cimjet[_3_] is offline
external usenet poster
 
Posts: 157
Default 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.