How to count the number of used rows in each of my 115 worksheets?

[rabbitfoot365]

How to count the number of used rows in each of my 115 worksheets (all in one workbook)?
I have all of the worksheet names in a row in a worksheet called Summary.
Seems simple but ..thx

 

[Joe4]

Is there a certain column that is always populated that we can look at to find the last row with data?
For example, for every row with data, is there ALWAYS something in column A (or some other specific column)?

 

[rabbitfoot365]

Yes, column A is always populated. Thanks

 

[Joe4]

OK, using the method found in the last reply here: Get the Row number of the last non blank cell in a column in Microsoft Excel, let's say that your sheet name appears in cell A2. Here is the formula to get the last used row in column A of that sheet:

=MAX(IF(ISBLANK(INDIRECT("'" & A2 & "'!A:A")),0,ROW(INDIRECT("'" & A2 & "'!A:A"))))

 

[rabbitfoot365]

I was able to use =COUNTA(INDIRECT("'" & A3 & "'!A:A")) Thanks

 

[Joe4]

I was able to use =COUNTA(INDIRECT("'" & A3 & "'!A:A")) Thanks

There is a little difference in our two methods and what they do.
The formula I provided will return the row number of the last used row in column A.
The formula you provided will count the number of rows in column A with something in them.

Where the results will differ is if there are blank cells in column A before the last row of data.