Results 1 to 2 of 2

Reference a sheet by number (not name) in a formula

Threaded View

  1. #1
    Forum Contributor Rhudi's Avatar
    Join Date
    03-08-2013
    Location
    South Carolina, US
    MS-Off Ver
    Professional Plus 2016 aka Office 365
    Posts
    201

    Reference a sheet by number (not name) in a formula

    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
    Last edited by Rhudi; 03-14-2013 at 05:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1