How can SUM use cell references in other cells?
 

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?

How can SUM use cell references in other cells?
 

Yes:


The INDIRECT() function will help you See Excel Help
--
Gary''s Student


"Phil G" wrote:

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?

How can SUM use cell references in other cells?
 

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

"Phil G" wrote:

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?

How can SUM use cell references in other cells?
 

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.

"Gary''s Student" wrote:

Yes:


The INDIRECT() function will help you See Excel Help
--
Gary''s Student


"Phil G" wrote:

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?