Hi, I want to sum n values in sheet 2, if the same rows in sheet1 it's the bottom n values.
For example:
<tbody>
</tbody>
So in this case, if n=3, the bottom 3 value are F, C, B.
So the formula should sum F,C,B in sheet 2: 20+14+15= 49
Thanks in advance
For example:
Sheet 1 | Sheet 2 | |||
A | 8 | A | 1 | |
B | 3 | B | 15 | |
C | 2 | C | 14 | |
D | 7 | D | 3 | |
E | 10 | E | 4 | |
F | 1 | F | 20 | |
G | 4 | G | 7 | |
H | 5 | H | 6 |
<tbody>
</tbody>
So in this case, if n=3, the bottom 3 value are F, C, B.
So the formula should sum F,C,B in sheet 2: 20+14+15= 49
Thanks in advance