Quick question...

i have two rows. F and H. F contains a series of random numbers. In cell H15 i will need to place the sum of the random numbers from F. However the tricky part is that the number of rows included in this sum is dictated by an integer variable I.

so for example

i = 5

means go to H15 will get the sum of F15 thru F20(count back i number of spaces).

Can some of the experts please help me figure out the other half of this equation to do this:

H15 = ?

Thank you.