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:A10 0<""),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??