+ Reply to Thread
Results 1 to 2 of 2

INDIRECT within COUNTIF

  1. #1
    Registered User
    Join Date
    01-12-2011
    Location
    Virginia
    MS-Off Ver
    MS Office 2016
    Posts
    11

    INDIRECT within COUNTIF

    Thank you in advance for any help you can lend.
    - Column A of Sheet1 lists worksheets containing data: 'Data1' and 'Data2'
    - Column B contains a COUNTIF function:
    Cell B1: =COUNTIF(Data1!B:B,"Apple")
    Cell B2: =COUNTIF(Data2!B:B,"Apple")

    I want to alter the formulas in column B to use the INDIRECT function, while referencing the worksheet names that are in column A


    Could someone please help with this?

    Thanks, Sven
    Last edited by svenn; 03-25-2020 at 07:18 PM.

  2. #2
    Registered User
    Join Date
    01-12-2011
    Location
    Virginia
    MS-Off Ver
    MS Office 2016
    Posts
    11

    Re: INDIRECT within COUNTIF

    =COUNTIF(INDIRECT("'"&A1&"'!B:B"),"Apple")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Can't add criteria to SUM(COUNTIF(INDIRECT
    By Ochimus in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-30-2019, 11:36 PM
  2. Using Indirect with Countif
    By swifty1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-06-2015, 11:48 PM
  3. Need Help with COUNTIF and INDIRECT function...
    By ckent0715 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-27-2014, 01:11 PM
  4. SUM, COUNTIF, and INDIRECT - Need help
    By bubbacheese in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2014, 10:49 AM
  5. [SOLVED] 2 data Range using COUNTIF with INDIRECT and MIN IF with INDIRECT,
    By david gonzalez in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-29-2013, 08:10 PM
  6. COUNTIF and INDIRECT
    By Simon Gahan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-21-2012, 05:52 AM
  7. INDIRECT COUNTIF's??
    By alymcmorland in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2005, 07:55 AM

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