Thread: Use a vlue of a cell for the sum range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Use a vlue of a cell for the sum range
Try this

=SUM(INDIRECT("A1:A"&C1))

A 5 in C1 would sum the range A1 - A5

Mike

"jimjudd" wrote:

I want to use value stored in a cell (lets say C1) to use for SUM function
range.
For example SUM(A1:AC1)
C1 bing a value stored in cell C1, may be 5
Reply With QuoteReply With Quote