# Excel - COUNT Function Problem - Expert Solution

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
Excelchat Expert 14/06/2018 - 03:54
Wow, this is a big file indeed.
Excelchat Expert 14/06/2018 - 03:54
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
User 14/06/2018 - 04:03
ok
User 14/06/2018 - 04:03
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
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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.