Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execel sum up
I am trying to sum up a range of cells. the number of
cells that need to be summed up is detemined by a number inputed into a reference cell. (this number could be change) eg. range of cells a1,b1,c1,d1,e1 etc. reference cell number is 3. therefore it should sum up a1,b1,c1. I am using Excel 2002 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execel sum up
=Sum(offset(A1,0,0,1,A2))
Assume A2 is the reference cell. -- Regards, Tom Ogilvy "Craig" wrote in message ... I am trying to sum up a range of cells. the number of cells that need to be summed up is detemined by a number inputed into a reference cell. (this number could be change) eg. range of cells a1,b1,c1,d1,e1 etc. reference cell number is 3. therefore it should sum up a1,b1,c1. I am using Excel 2002 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formaulating in Execel | Excel Worksheet Functions | |||
Execel Form | Excel Discussion (Misc queries) | |||
Execel Macro | Excel Discussion (Misc queries) | |||
what is execel | Excel Discussion (Misc queries) | |||
Execel Question | Excel Worksheet Functions |