ExcelBanter - Use a vlue of a cell for the sum range

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Use a vlue of a cell for the sum range (https://www.excelbanter.com/new-users-excel/193445-use-vlue-cell-sum-range.html)

jimjudd

Use a vlue of a cell for the sum range

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

Mike H

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

jimjudd

Use a vlue of a cell for the sum range

Thank you Mike for your help :0)

"Mike H" wrote:

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

All times are GMT +1. The time now is 02:58 PM.