I have a formula that counts rows on another sheet.
It does it by sheet name, like:
=COUNTIF(SHTNAME!A:A,"?*")-1
The name will change.
How can I do that with a number, instead of the name?
=COUNTIF(?????!A:A,"?*")-1
=COUNTIF(Sheets(3)!A:A,"?*")-1 obviously doesn't work.
FIGURED IT OUT... Actually, I just figured out by accident that it is dynamic. If I change the tab name, the formula changes too. :P
Bookmarks