Thread: How can SUM use cell references in other cells?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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?
Reply With QuoteReply With Quote