Sum column - parameter

O

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.
 
M

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)
 
O

Oscar

Exactly what I was looking for.

Thanks, Oscar.

Max said:
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)
Click to expand...
 
Top