for example, if i wanted to sum the last three cells in the following range, the formula would yield -- 8.

2

3

5

2

1

and for this range, again if i wanted to sum the last three cells, the formula would yield -- 10.

3

4

5

2

1

4

5

thanks in advance for the help