Results 1 to 7 of 7

Formula references - Referencing other tabs through auto lookups

Threaded View

  1. 01-02-2021, 08:46 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,301

    Re: Formula references - Referencing other tabs through auto lookups

    You'll need to use INDIRECT - in Calculator!B2:

    =COUNTIFS(INDIRECT(TEXT(Admin!A1,"mmmyy")&"!B:B"),1,INDIRECT(TEXT(Admin!A1,"mmmyy")&"!C:C")

    Correction:

    =COUNTIFS(INDIRECT(TEXT(Admin!A1,"mmmyy")&"!B:B"),1,INDIRECT(TEXT(Admin!A1,"mmmyy")&"!C:C"),1)
    Last edited by AliGW; 01-02-2021 at 09:03 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sumif and Hlookup formula referencing multiple tabs to create summary tab
    By kgilmore in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-05-2019, 03:14 PM
  2. Maintain Formula References when replacing tabs
    By maddogp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2015, 03:17 PM
  3. [SOLVED] Formula that references different tabs according to a data validation field?
    By Rizzu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-27-2012, 06:27 PM
  4. autofill a formula that references worksheet tabs
    By menziesthefish in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-29-2010, 10:50 AM
  5. Help with a formula referencing multiple tabs
    By CIP in forum Excel General
    Replies: 3
    Last Post: 09-08-2009, 10:11 AM
  6. Dragging a formula referencing multiple tabs
    By gvb in forum Excel General
    Replies: 0
    Last Post: 03-05-2008, 02:21 PM
  7. Lookups and References in relations to countA or sumproducts
    By JR573PUTT in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-15-2006, 03:55 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1