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.

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.

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.

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.