| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum column - parameter
How can I sum n-th column (n is parameter)? Something like =sum(E:E). Tried
with offset but doesn't work with E:E as it works with E1:E100. Thanks, Oscar. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum column - parameter
In say, B2: =SUM(OFFSET(A:A,,4))
will return the same as: =SUM(E:E) (col param = 4 = 4 cols to the right of anchor col A) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Oscar" wrote: How can I sum n-th column (n is parameter)? Something like =sum(E:E). Tried with offset but doesn't work with E:E as it works with E1:E100. Thanks, Oscar. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum column - parameter
Exactly what I was looking for.
Thanks, Oscar. "Max" wrote: In say, B2: =SUM(OFFSET(A:A,,4)) will return the same as: =SUM(E:E) (col param = 4 = 4 cols to the right of anchor col A) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Oscar" wrote: How can I sum n-th column (n is parameter)? Something like =sum(E:E). Tried with offset but doesn't work with E:E as it works with E1:E100. Thanks, Oscar. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum column - parameter
Welcome, Oscar.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Oscar" wrote in message ... Exactly what I was looking for. Thanks, Oscar. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
| Lookup funtion: column index number (third parameter) | Excel Worksheet Functions | |||
| What does the second parameter in ACCRINT do? | Excel Worksheet Functions | |||
| parameter query help | Excel Discussion (Misc queries) | |||
| Parameter Query? | Excel Discussion (Misc queries) | |||
Hybrid Mode
