Finding non contiguous positive values

[Nick Krill]

I'm using the following to sum the last 10 non blank cells in column A (which
has over 500 rows with empty cells randomly distributed):

=Sum(A100:Index(A1:A100,Large(Row(A1:A100)*(A1:A100<>""),10)))

Now I need to find how many of those 10 cells have positive numbers so that
I can then divide by 10 and arrive at a percentage of positive cells. Any
suggestions??

 

[Domenic]

Try...

=COUNTIF(INDEX(A1:A100,LARGE(IF(A1:A100<>"",ROW(A1:A100)-ROW(A1)+1),10)):
A100,">0")

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!