Alternative to nested if statement

[Forumconnemara]

Hi Folks,

I have just found out that you can have a max of 7 if statements in excel 2003. I am looking for an alternative solution. My dilemma:

I want to select the max value cell in the range of a specific column (that I can do), then I want to add this max value to the value of cells in the rows above it in another column. I have tried multiple IF with MAX but I am limited to 7 and I need up to 10.

See the attached file for an example, what I want to do is:
Add the max from the range D3: D12 (yellow column) to the sum of the cells
in the rows above it in the range G3:G12 (blue column).

E.G.
if max is D3 then the value returned should be D3
if max is D4 then the value returned should be D4+G3
if max is D5 then the value returned should be D5+sum(G3:G4)
if max is D6 then the value returned should be D6+sum(G3:G5)

Or as the case in the example I sent you then the max returned would be
D9+sum(G3:G8)

I have researched it a fair amount and even to get pointed in the right direction would be appreciated.

Thanks for any assitance.

Joe.