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

V

V L

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

trip_to_tokyo

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

EXCEL 2007

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

Cimjet

Hi
Not sure if i understand but try this :
=counta(A3:A200)
Adjust the range to your needs.
Cimjet
 

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

Function for summing or counting cells based on a specified fill color 3
How to count the numbers in a Word document? 0
Is there a function to count how many times a cells value is used? 0
Place picture in Excel cell 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
How do I install Microsoft Equation 3.0 back to Office 365? 0
vlookup or some other function that counts rows 0
Creating Labels Over 3-Up Image 2

Top