Help with Counting by Dynamic Range & Skip Blanks

[nc_waggoner]

Hello, I have a reference sheet linked to a Sharepoint file similar to the format below. The blanks do contain the reference formula which is causing issues. I need to figure out how to get the percentage of data points above 1.1 based on the last 10 days with values. So for example, 11/15/17 for column 1 would be 60% since it would cover 11/5 to 11/5 (this does not include 11/8 due to being blank). 11/16 would cover the same range since it too is blank. The idea is to get a daily tracker to see if the percentage above 1.1 is improving or getting worse. How would I set up the formula to count anything above 1.1 based on the last 10 cells with data/numbers (not blanks or formulas). Thank you!

Date	Column 1	Column 2	Column 3
11/1/2017	100	1.1
11/2/2017	1.1	1.1	100
11/3/2017	1.1	1.1	1200
11/4/2017		100	1500
11/5/2017	10		100
11/6/2017	250
11/7/2017	1.1	1.1	1.1
11/8/2017		1500	1.1
11/9/2017	2000	850	1.1
11/10/2017	100	100	1.1
11/11/2017	1.1	1.1	250
11/12/2017	1.1		500
11/13/2017	1.1	1.1	1.1
11/14/2017	100	1.1
11/15/2017	1200	1.1	100
11/16/2017		1.1	1.1

<colgroup><col span="4"></colgroup><tbody>
</tbody>