SUM to upper value specified in a cell

[3thr3e]

Hi,

I need to SUM from B1 up to a cell reference I've generated using:

=ADDRESS(ROW(A1:A113)+MATCH(I8,A1:A113,FALSE)-1,COLUMN(A1:A113)+1)

For example, if the output of the above was $B$20 I would want:

SUM($B$1:$B$20)

But if I enter:

SUM($B$1:ADDRESS(ROW(A1:A113)+MATCH(I8,A1:A113,FALSE)-1,COLUMN(A1:A113)+1))

it doesn't work. Must be an easy solution?

Many thanks in advance.

Tim

 

[shift-del]

Hi Tim

=SUM(B1:INDEX(B:B,MATCH(I8,A1:A113;0)))

 

[3thr3e]

Hi Tim

=SUM(B1:INDEX(B:B,MATCH(I8,A1:A113;0)))

Thanks so much, worked a treat!