Was wondering if there is an IFcount formula for this scenario?


Below on Sheet 1

A B C
1 125 58 183
2 896 876 20
3 500 11 511
4 244 5 249

Then on sheet two

A
1 would like this vale to be the count of b1:b4 if c1:c4 is greater or
equal to 98%. In this case it would be 3 because on sheet 2 c2 is 97.8% of
the difference of b2 and a2. I hope I explained it correctly.

Thank You in advance......