software

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(quot;Aquot;,B1)). Is there any way to do this?

Yes:The INDIRECT() function will help you See Excel Help
--
Gary''s Studentquot;Phil Gquot; wrote:

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

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

quot;Phil Gquot; wrote:

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

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.

quot;Gary''s Studentquot; wrote:

gt; Yes:
gt;
gt;
gt; The INDIRECT() function will help you See Excel Help
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;Phil Gquot; wrote:
gt;
gt; gt; I will be given a list of numbers (starting in A1) together with the number
gt; gt; of numbers in the list given in B1. I would like to be able to write
gt; gt; =SUM(A1,CONCATENATE(quot;Aquot;,B1)). Is there any way to do this?