13

« **on:** December 13, 2007, 08:39:35 PM »
I am trying with s, but my total score comes out as 0 for all players. The formula is if(s<=2,0,sum(top(7,scores))). You are right about the n, it posted a score for every player, whether they played in 1 tournament or 3. But it it filtering a total of 3 tournaments and many players have 3 scores, but it's showing up as 0.

if(numberofscores<=2,0,sum(top(7,scores))) doesn't work either.

I also tried if(numberofscores>2,0,sum(top(7,scores))) and if(s>2,0,sum(top(7,scores))) and I get the same result, a 0.

I know that the "top" and "bottom" functions are working properly since when I used n, it gave me a score. I have another formula that drops the players lowest score, if(s<=2,0,sum(sum(top(7,scores))-sum(bottom(1,scores)))). It also give a 0 with s but does the calcs ok (although incorrectly as you mentioned) with n.