Counting the number of rows

  • Thread starter Thread starter blurboiboi
  • Start date Start date
B

blurboiboi

Hi... is there any way I can determine the number of rows used usin
formula instead of macro?...

The number of rows would constantly be increasing..
 
You can count how many cells in a column contain numbers using =COUNT(A:A),
and how many cells contain anything using =COUNTA(A:A)
*******************
~Anne Troy

www.OfficeArticles.com
 
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 number of rows with specific text 2
I am using the COUNT function to determine the 1
Match and delete rows on two different sheets from reference numbers 4
COUNT rows on external sheet if between date range 3
one cell in a row contains a number 7
count identical values in 2 rows 7
Excel Help to copy information from one row at a time to another sheet 1
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2

Back
Top