Results 1 to 2 of 2

Thread: Use cell Data to point to another sheet in formula?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2014
    Posts
    100
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Use cell Data to point to another sheet in formula?

    I am looking to use a formula that counts data in another sheet in the same workbook but use a cell data info to get the right sheet. I have sheets named 2017, 2018, 2019, ect and need to have my countif formula in another cell to look for data in the correct sheet depending on the data in another cell. So lets say, A1 has 2018 in that cell. In A2 I have the word "APPLES". In A3 i want to know how many "APPLES" there are in sheet 2018 in col A. Formula should look like this i think:

    =countif(' =A1 '!A:A,A2)

    The =A1 would get 2018 from that cell and needs to know to go to the sheet 2018 and then count.

    Can this even be done?

    Thanks in advance.

    Mike

  2. #2
    MrExcel MVP
    Join Date
    May 2009
    Posts
    16,590
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Use cell Data to point to another sheet in formula?

    Try:
    =COUNTIF(INDIRECT(A1&"!A:A"),A2)
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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