Counting multiple fractions, separated by commas, inside multiple cells, only if the number is larger than a certain threshold(80%)

[OBE]

Hi, I am looking for a formula that can count the number of fractions 80% or larger in a range(in which cells can have multiple fractions inside, separated by commas), with the exception of 5/7, which should be counted despite being smaller than 0.8.
For example, if the selected range is like this:

8/10, 5/7

2/1

9/10

I want the end result to be 3, counting 8/10, 5/7, and 9/10.
I'm still very new to excel, so if you have the time and courtesy to provide step-by-step explanation, I'd be much appreciated since I want to learn more about this program.
English is not my first language, so if there's anything that reads rude, I'm sorry! I tried my best to write as politely as possible
(English grammar and expressions corrections are welcome, too!)

Thank you!

OBE

 

[bebo021999]

Is code/macro accepted?
Ii 2/1 or 9/10 text string, or value with fraction format?

 

[OBE]

Is code/macro accepted?
Ii 2/1 or 9/10 text string, or value with fraction format?

I'm so sorry for being late. Regarding code/macro, while I'm not sure what code is, sure! As long as it is not too heavy on computers. I'm not so sure about fractions though. I just type in the fractions manually with no specific format assigned to it. But since all the cells in the range of interest preferably have the same format, I guess it can't be fraction format.

 

[bebo021999]

Assum data in A1,B1,C1. Which cell is expected result? D1?
Also A2,B2,C2 ? and down?
Could you post a screenshot?

 

[OBE]

Assum data in A1,B1,C1. Which cell is expected result? D1?
Also A2,B2,C2 ? and down?
Could you post a screenshot?

Oh, I think I made a mistake. n>=6 Jn should check Hn and count fractions with forementioned conditions(>=80% or 5/7)
I'm afraid I can't provide you the screenshot. I'm so sorry T-T

 

[bebo021999]

Still not clear.
Working with sample is OK, but i need to see whole picture.

 

[OBE]

Still not clear.
Working with sample is OK, but i need to see whole picture.

 

[OBE]

Still not clear.
Working with sample is OK, but i need to see whole picture.

This is the end result I want Column H is filled manually, and I want column J to fill itself automatically.

 

[OBE]

Still not clear.
Working with sample is OK, but i need to see whole picture.

I'm so sorry if i'm frustrating Thank you for sticking with me though!