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.
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