Sum column - parameter

[Oscar]

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.

 

[Max]

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)

 

[Oscar]

Exactly what I was looking for.

Thanks, Oscar.

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]

Welcome, Oscar.