Your formula could be replaced by

=SUM(OFFSET(Bronze!B1,,,L21,))

I have no idea what you're talking about after that, since you didn't
keep your reply in the same thread...

In article ,
"Jackanorry" wrote:

After OzziJC reply, I went back to the IF function.

Using the following does return the correct value for the first calculation.
=IF(L21=1,SUM(Bronze!B1),IF(L21=2,SUM(Bronze!B1:B2 ),IF(L21=3,SUM(Bronze!B1:B3)
,IF(L21=4,SUM(Bronze!B1:B4)))))

It will not however work in the second to sixth calculation, do to the
number of "allowed' calculations - the number of values a
The second range of numbers 5 - 20
The third range of number 21 - 84
The fourth range of number 85 - 340
The fifth range of numbers 341 - 1364
The sixth range of numbers 1365 - 5460

I've attempted to write a nested formula and an array formula - neither
which have worked - yet!

Once again any help/guidance would be greatfully appreciated.