Results 1 to 4 of 4

Creating a range within INDIRECT Function (help needed)

Threaded View

  1. 02-14-2023, 03:19 PM #1
    Liondj77
    Liondj77 is offline
    Registered User
    Join Date
    02-14-2023
    Location
    US
    MS-Off Ver
    365
    Posts
    2

    Creating a range within INDIRECT Function (help needed)

    I am trying to update a function so that cell references A3 and A4 become range references. For example, I have 10 worksheets I want to sum cell F38 from. A3 would be Sheet 1 and A4 would be sheet 10. Right now it is only summing F38 from Sheet 1 and Sheet 10, and nothing in-between. Does anyone have a fix? See below for current formula.

    This is also a formula where I would like to keep A3 and A4 to updatable references, for example I would easily be able to change the "values" within those cells so that I can expand the reference in the future.

    =SUMPRODUCT(SUMIF(INDIRECT("'"&A3:A4&"'!f38"),"<>0"))
    Attached Files Attached Files
    Last edited by Liondj77; 02-14-2023 at 03:27 PM.
    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. [SOLVED] Issue creating a dependent drop down list with indirect function
    By Grilleman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-04-2022, 02:23 AM
  2. [SOLVED] Possible Indirect Function Needed or Any feasible method
    By cvici in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2021, 01:42 PM
  3. Help creating a function with indirect ref
    By nymark in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2020, 02:45 PM
  4. Help needed with 'Indirect' function
    By sumdumgai in forum Excel General
    Replies: 6
    Last Post: 03-06-2017, 12:01 AM
  5. [SOLVED] HELP NEEDED: INDIRECT combined with ROW function
    By dtheb in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-20-2016, 12:41 PM
  6. Multi Tier - Match & Vlookup or INDEX or INDIRECT function help needed
    By yogananda.muthaiah in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2016, 12:32 AM
  7. [SOLVED] Foruma needed to integrate indirect and sumif function
    By VincentNL in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-01-2014, 10:45 AM

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