How can SUM use cell references in other cells?

[Phil G]

I will be given a list of numbers (starting in A1) together with the number
of numbers in the list given in B1. I would like to be able to write
=SUM(A1,CONCATENATE("A",B1)). Is there any way to do this?

 

[Gary''s Student]

Yes:


The INDIRECT() function will help you See Excel Help

 

[bpeltzer]

I'd use offset: =sum(offset(a1,0,0,b1,1)).

 

[Phil G]

Many thanks for the prompt and helpful reply - I should have found this
myself! _ someday I'll have to go through all the functions in detail.