countif-sumif combination??

I want to count how many cells in the OS cloumn have a 9 or 10 that also have a 1 in LOS column and compare that to the 9 or 10 in the OS that have LOS greater than 1 and express those results as a percentage of the total number in each LOS category (also to be noted is there will never be a zero value for any, only a blank if data is not reported). Under the data I have the results I need based on manually calculating from the sample data. In reality I need to do this with 50-200 data entries accumulated monthly so that is why i'm looking for a formula but I do not know what will work.... In the data sample each column is alternated bold. Thanks in advance for any help!

# LOS OS CR CB
427 1 9 7 7
509 3 10 9 9
512 1 10 10 10
1228 2 8 8 8
1107 4 9 10
918 3 7 8
1530 1 9 9

[LOS>1, OS=9 or OS=10] 2 out of 4, 50%
[LOS=1, OS=9 or OS=10] 3 out of 3, 100%

I'd like this same analysis for OS, CR & CB all relating back to LOS=1 and LOS>1

Here you go:

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Attachment 259058

Thank you both for the help, I appreciate it very much!

I have a follow up problem though....
I also want to analyze the OS, CR & CB by #. The # column is a specific area in a more general region. The refions are 4-15 and correspond to the first digits of the #. I created a "hidden" column in my formatting that gives the region of each entry and when i adapted the sumproduct formula to get the new results I keep getting a zero return but I know it is not correct. I've attached the actual spread sheet i'm working with as well.

What value do you want to be in O9? Are you simply attempting to add up the numbers?

Why are there two ranges instead of one continuous list?

In O9 I should get a value of 0.8 because there are 5 entries from region 4 and 4 of the 5 have a 9 or 10 result.
And I need to do the same for every region in the 2 categories of CR and CB.

I have 2 columns of entries so I just added them together because i don't know how to have a continuous range from 2 columns