Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count number of row where are data
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 |
#2
|
|||
|
|||
Hi
=COUNTA(A:A) "Maileen" wrote: 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 |
#3
|
|||
|
|||
It returns 0 because i'm not checking cells where are written figures, but
text (main of the time)... :( something else ? Maileen "Frank Kabel" wrote: Hi =COUNTA(A:A) "Maileen" wrote: 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 |
#4
|
|||
|
|||
You've got a couple of responses to your other post over at
..worksheet.functions -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |