+ Reply to Thread
Results 1 to 5 of 5

How to apply correctly SUM INDIRECT to non continuous column?

  1. #1
    Registered User
    Join Date
    06-21-2015
    Location
    fort lauderdale, florida
    MS-Off Ver
    2007
    Posts
    77

    Unhappy How to apply correctly SUM INDIRECT to non continuous column?

    Hi all,


    What i'm trying to achieve is the sum of 2 cells located in non continuous column,
    my main purpose is to keep at all the time the same cell references with formulas.
    (i have to apply INDIRECT in a hundreds of cell that use different formulas)
    i used various (and some insane lol ) formulas and I'm receiving an REF Error or ####

    Cell F4 have 1 and Cell H1 have 0,

    these are the following formulas applied with not success
    Please Login or Register  to view this content.


    Thank you in advance
    Last edited by Franky alta; 06-28-2015 at 01:16 PM. Reason: add the word non

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to apply correctly SUM INDIRECT to non continuous column?

    One way...

    =SUM(SUM(INDIRECT({"F4","H4"})))

    That formula will ALWAYS refer to F4 and H4 no matter what!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    06-21-2015
    Location
    fort lauderdale, florida
    MS-Off Ver
    2007
    Posts
    77

    Re: How to apply correctly SUM INDIRECT to non continuous column?

    Hi Tony,

    Thank you!, It worked

    I'm sorry the system don't let me add you a reputation *
    it said "You must spread some Reputation around before giving it to Tony Valko again."

    soon..

    Thank you again!!

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: How to apply correctly SUM INDIRECT to non continuous column?

    You're welcome. Thanks for the feedback!

  5. #5
    Registered User
    Join Date
    06-21-2015
    Location
    fort lauderdale, florida
    MS-Off Ver
    2007
    Posts
    77

    Re: How to apply correctly SUM INDIRECT to non continuous column?

    Hi Tony,

    I' sorry for a new question, (it might be better for a new tread)
    Applying the same INDIRECT the same way in a Long array formula, i tried it and din't work

    I'll post another tread because it confuse me, this formula have and '=' between the ranges


    thank you!

+ 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] Incorporate the INDIRECT function correctly into a formula
    By Harribone in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-22-2014, 04:38 PM
  2. [SOLVED] Nested INDIRECT Command Not Populating Correctly
    By lordfa9 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-17-2014, 11:40 PM
  3. [SOLVED] Continuous column copy / Non-continuous column paste (VBA)
    By macrorookie in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-05-2014, 11:35 PM
  4. Any shortcuts to apply the INDIRECT function?
    By sam beginer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-22-2013, 12:36 AM
  5. why doesn't this INDIRECT resolve correctly?
    By hank_t in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2012, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1