How can I make this work? I keep getting the formula too long error.

=if(j4=1,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<3,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<7,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<11,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<15,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<19,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<23,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<27,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<31,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<36,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<41,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<46,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<52,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<58,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<64,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<70,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<75,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<80,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<85,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<90,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<95,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<100,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<105,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
if(j4<110,sum('Upgrades-Beta'!b76:'Upgrades-eta'!b100),
if(j4<115,sum('Upgrades-Beta'!b76:'Upgrades-Beta'!b100),
0)))))))))))))))))))))))))

TIA!
Lady Olara