• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

Excel Formula

=SUM(INDIRECT(ADDRESS(1, 24) & ":" & ADDRESS(14, 24)))

What the usage for INDIRECT & ADDRESS used in Excel formula ? What does the above formula mean ?

Tks
0
AXISHK
Asked:
AXISHK
2 Solutions
 
Rory ArchibaldCommented:
ADDRESS(1,24) returns $X$1
ADDRESS(14, 24) returns $X$24

INDIRECT("$X$1:$X$24")
returns a reference to the range X1:X24 and SUM then adds it up. You can use the Evaluate Formula button on the formulas tab to see the steps. ;)
0
 
Hakan YılmazTechnical Office MEP EngineerCommented:
INDIRECT function turns a "String" value to "Range Reference".
You can use both A1 and R1C1 references together with help of this function.
ADDRESS function produces address of a range as "String", from parameters you give.

Your formula always sums X1:X14 (X is 24th column) in same sheet with formula.
0
 
AXISHKAuthor Commented:
Tks
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now