CODEWITHSUNDEEP
excelexcel-formulaworksheet-functionexcel-indirect
Joshua Tan
Joshua Tan

Reputation: 356

Set range in formula via a cell

Is there a way to set the range of a formula by reference to another cell's content? I need the formula to be dynamic based on what I key. For example, I need the formula: Sum(A1:B10), is there a way to do this:

=Sum("RefrenceCellC1" : "RefrenceCellC2")

(where C1 = A1 and C2 = B10), so if I change cell C2 content to B20 the formula then becomes: Sum(A1:B20)?

Upvotes: 1

Views: 149

Answers (1)

pnuts
pnuts

Reputation: 59442

For the sake of an answer (as alluded to by @tigeravatar): 

=SUM(INDIRECT(C1&":"&C2))

Upvotes: 1

Related Questions