Count number of row where are data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a sheet on which an amount of rows have data (for example : 156 rows)
based on different sheets, I would like to retreive the number of row where
are data. for example :

sheet 1 has 156 rows
sheet 2 has 257 rows
sheet 3 has 4 rows.

I thought i could do it using COUNTIF but i don't remember the criteria that
i have to place.
i just want to count how many rows have the A cell not empty.
thx,
Maileen
 
It returns 0 because i'm not checking cells where are written figures, but
text (main of the time)... :(
something else ?

Maileen
 
You've got a couple of responses to your other post over at
..worksheet.functions
 
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

How to filter rows data based on background color of individual cells 1
Summary Worksheet. 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Extract Data to Creat Short List 5
Get the row count of different areas in the Excel 2
Copy data from unlocked cells 3
How to insert new worksheet based on # of rows in a data sourch 2
copy rows from one Data sheet to another sheet based on cell conte 2

Back
Top