Results 1 to 2 of 2

Thread: referring to a worksheet name in a formula.

  1. #1
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0

    referring to a worksheet name in a formula.



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Can you refer to the name of a worksheet in a formula?
    I have a work around this so far by just putting the name of the worksheet in cell A1 then referring to that cell,
    but I don't want to have to code that all the time when my sheet names are the value I want.

    Also I need help with a sum formula. I want to get a sum of cell A5 to (end of entered data).

    Thank you,

    Simi

  2. #2
    Super Moderator Zack Barresse's Avatar
    Join Date
    Mar 2011
    Location
    Oregon, United States
    Posts
    106
    Articles
    0
    Hello Simi,

    To sum column A, you can just use SUM(A:A) and it will ignore text. If you want a dynamic range, you could use something like this ...

    Code:
    =SUM(A5:INDEX(A:A,MATCH(9.999E+307,A:A),1))
    To get the name of the worksheet as a formula, you can use something like this ...

    Code:
    =RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))
    Or if you download and install ASAP Utilities you can use the built-in function...

    Code:
    =ASAPSHEETNAME()
    There are other add-ins with this similar function because 1) it's not a native function, and 2) it's asked for quite often.

    HTH
    Regards,
    Zack Barresse

Posting Permissions

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