Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect cell reference
I am trying to do a sum on certain sections of a list that is dynamic. So if
you assume you have a list of 100 cells in a column, and you determine that you want to sum the values in three sections of this list. The start and end rows of this list are in cells a1:b3. How would i use the sum function to sum the values in these three sections? Thanks in advance for your help! Tom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
indirect cell reference
TomCser wrote:
I am trying to do a sum on certain sections of a list that is dynamic. So if you assume you have a list of 100 cells in a column, and you determine that you want to sum the values in three sections of this list. The start and end rows of this list are in cells a1:b3. How would i use the sum function to sum the values in these three sections? Thanks in advance for your help! Hi Tom, Let's say your value cells are in C1:C100. I'm assuming columns A and B are "start" and "stop" row numbers to sum. Then this works: =SUM(OFFSET(C1,A1-1,0,B1-A1+1))+SUM(OFFSET(C1,A2-1,0,B2-A2+1))+SUM(OFFSET(C1,A3-1,0,B3-A3+1)) There are probably more elegant ways though. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect sheet reference in a cell | Excel Worksheet Functions | |||
Dynamic cell reference using INDIRECT.. | Excel Worksheet Functions | |||
Cell reference OR INDIRECT function | Excel Worksheet Functions | |||
Can INDIRECT function reference a cell that contains a formula | Excel Worksheet Functions | |||
Cell reference within a indirect.. | Excel Worksheet Functions |