Sum if large

[Samgar]

I'm trying to combine a Sum IF and large formula.
My Sum if formula is =SUM.iF($P$7:$P$300;$A$7:$A$300;AA39;$R$7:$R$300;"Forc")

And I want to sum the largest of $P$7:$P$300, i would like, if possible, how many of the largest numbers to sum to be based on AH39.

 

[Canapone]

Hi,

an attempt.

Numbers in P7:P300 (294 numbers), in AH39 the number of largest numbers under the condition R7:R700="forc" you need to sum.

=SUMPRODUCT(IFERROR(AGGREGATE(14,6,P7:P300/(R7:R300="Forc"),INDEX(((ROW(7:300)-6)<=AH39)*(ROW(7:300)-6),)),0))

Regards