Thread: Use the content of a cell in the sum (or other) functions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michele Foley Michele Foley is offline
external usenet poster
  
Posts: 1
Default Use the content of a cell in the sum (or other) functions
Example of what I want to achieve:

Column A has many rows with numbers.

D1= a text cell that reads textually A1:A20

I am looking for a formula that will give me the sum of the VALUE that D1,
gives me i.e. SUM(A1:A20). I do not want to define names for the range A1:A20
because the range changes frequently in in my particular spreadsheet I would
have to redefine approx 200 names each time.

Can anyone help me?
Reply With QuoteReply With Quote