**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need to count the number of data/rows in a sheet

Solved by O. U. in 37 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
14/06/2018 - 03:53

Hello!

Excelchat Expert
14/06/2018 - 03:53

Hello, welcome to got it pro.

User
14/06/2018 - 03:53

Here is the file, please downlaod

User
14/06/2018 - 03:53

https://drive.google.com/file/d/1QeBpD_Bkkx5Jirtt1oNkUux5g__lFsEP/view?usp=sharing

Excelchat Expert
14/06/2018 - 03:54

Wow, this is a big file indeed.

Excelchat Expert
14/06/2018 - 03:54

Downloading now.

User
14/06/2018 - 03:55

sorry, just seen the size of the file

Excelchat Expert
14/06/2018 - 03:56

I would take 8/10 minute on my pc to download the file. :'(

User
14/06/2018 - 03:57

ok np

User
14/06/2018 - 03:58

just to brief you about the project

Excelchat Expert
14/06/2018 - 03:58

I'm listening...

User
14/06/2018 - 03:58

there are around 34 sheets in the file.. 33 with the data in it + 1 with the overview and link to all file

User
14/06/2018 - 03:59

what I need is

User
14/06/2018 - 03:59

I want to know the number till where the last row of a sheet is filled

User
14/06/2018 - 04:01

like if sheet1 have data in it from A1 to H1 till A100 to H100....sheet2 A1 to H1 till A200 to H200

User
14/06/2018 - 04:02

I want to see in overview sheet: Sheet1 = 100 and sheet2=200 and so on

User
14/06/2018 - 04:02

Am I making anysense?

Excelchat Expert
14/06/2018 - 04:02

Yeah totally.

Excelchat Expert
14/06/2018 - 04:03

I'm just not sure If I can do that or if it is possible to do with formula.

User
14/06/2018 - 04:03

great :)

Excelchat Expert
14/06/2018 - 04:03

Please give me some time.

User
14/06/2018 - 04:03

ok

User
14/06/2018 - 04:03

please try

User
14/06/2018 - 04:03

sure, take you time :)

Excelchat Expert
14/06/2018 - 04:03

I'm trying my best. I think it would take another 3/4 minutes to finish the download and then I will make attempt.

Excelchat Expert
14/06/2018 - 04:05

I have read your problem overview again, you just looking for the row count, right? Please correct me if I'm wrong.

User
14/06/2018 - 04:06

yes correct

User
14/06/2018 - 04:06

row count till where the data is fille

Excelchat Expert
14/06/2018 - 04:06

Thank you for confirming.

User
14/06/2018 - 04:06

*filled

Excelchat Expert
14/06/2018 - 04:07

download finished.

User
14/06/2018 - 04:07

great!

User
14/06/2018 - 04:09

please work on it and I will be away from the system for few mints

User
14/06/2018 - 04:09

hope, I have cleared everything up

Excelchat Expert
14/06/2018 - 04:09

Everything is clear.

User
14/06/2018 - 04:09

I am extending the time for you

Excelchat Expert
14/06/2018 - 04:09

Please extend the time before you go.

Excelchat Expert
14/06/2018 - 04:09

Thank you.

User
14/06/2018 - 04:10

Done

User
14/06/2018 - 04:10

Welcome :)

Excelchat Expert
14/06/2018 - 04:19

=COUNTA(INDIRECT("'"&A2&"'!A:A"))

Excelchat Expert
14/06/2018 - 04:20

Please use this formula in D2 of Kutools for Excel sheet.

Excelchat Expert
14/06/2018 - 04:20

And then copy the formula for the rest of the cells to get count for every other sheets.

User
14/06/2018 - 04:24

D2?

User
14/06/2018 - 04:25

ok

User
14/06/2018 - 04:25

got it

Excelchat Expert
14/06/2018 - 04:25

=COUNTA(INDIRECT("'"&A2&"'!A:A")) this formula will give you the count of rows in sheet name of cell A2.

User
14/06/2018 - 04:25

thanks :)

Excelchat Expert
14/06/2018 - 04:26

Great.

Excelchat Expert
14/06/2018 - 04:26

I'm happy to be able to help.

Excelchat Expert
14/06/2018 - 04:27

Do you have any question?

User
14/06/2018 - 04:27

just want to know was that a easy task or use of Kutools helped you. I want to see whether buying the software was useful for me or not :)

Excelchat Expert
14/06/2018 - 04:28

I have no idea what kutools offering. But yeah, it was easy for me to write the formula once I got the problem clearly.

Excelchat Expert
14/06/2018 - 04:29

And of course I haven't used Kutools never even this time.

User
14/06/2018 - 04:29

ok :)

Excelchat Expert
14/06/2018 - 04:29

Anything else?

User
14/06/2018 - 04:29

thanks for your quick solution

Excelchat Expert
14/06/2018 - 04:29

Thanks for your patience, my apologies for the relatively slow internet connection I'm using.

Excelchat Expert
14/06/2018 - 04:30

Otherwise I would have provided the solution much earlier.

User
14/06/2018 - 04:30

I got the solution..All good

Excelchat Expert
14/06/2018 - 04:30

Please close this chat now.

User
14/06/2018 - 04:30

ok bye

Excelchat Expert
14/06/2018 - 04:30

Thanks and have a great day!

User
14/06/2018 - 04:30

have a nice day..cheers!!!!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*