mercredi 1 avril 2015

Excel, counting positive numbers such that next column is top 10

I am looking to count/sum positive numbers in a column given that we are taking only top 10 in next column. For e.g.


Sample data


I am using the formula: =SUM(LARGE(IF($E$3:$E$58>0,$F$3:$F$58),ROW(A1:A10)))


But it is summing the top 10 right F column such that E column is positive, which is the other way round. Any help is appreciated.


Aucun commentaire:

Enregistrer un commentaire