I have table of contents which lists all sheets in my workbook. I am trying to write a formula next to the sheet name that provides the number of items on each sheet that need to be reviewed. Basically a count of rows in column A of each sheet starting with row 5. The sheets are numbered like so but the description after each is unique.
<tbody>
</tbody>
I was trying to substitute the sheet name from the table contents with a COUNTA formula using single/double quotes but couldn't get it to work. Is it possible to do something like that? And I used 10,000 for the ending row as I know the hghest total from any sheet is ~800. Thanks
01. abc |
02. def |
03. ghi ...etc |
<tbody>
</tbody>
I was trying to substitute the sheet name from the table contents with a COUNTA formula using single/double quotes but couldn't get it to work. Is it possible to do something like that? And I used 10,000 for the ending row as I know the hghest total from any sheet is ~800. Thanks
Code:
=COUNTA('01. abc'!$A$5:$A$10000)