Sum if it's bottom n values in other sheet

[reagk]

Hi, I want to sum n values in sheet 2, if the same rows in sheet1 it's the bottom n values.
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

 

[reagk]

Oh, that's right, you need the 3 minor numbers, not the ones that are less than 3

How about:

=SUMPRODUCT((sheet1!B2:B9<=SMALL(sheet1!B2:B9,D2))*(B2:B9))

Thanks guys

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.