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
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.
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!!
You're welcome. Thanks for the feedback!
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks