Hello,

I use the following formula to sum top 5 values in a column:
=IF(V4>0,SUMPRODUCT((V$11:V$1007>LARGE(V$11:V$1007,6))*(V$11:V$1007)),"")
I added a flag column: "count Yes/No".

I wish to sum top 5 values where flag value is "Yes"

I tried:
=IF(V4>0,SUMPRODUCT((V$11:V$1007>LARGE(V$11:V$1007,6))*(V$11:V$1007)*(U$11:U$1007="Yes")),"")
but it does not work.

Can you help me ?

Thank you