how would i sum the last xx cells in a dynamic range?
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
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