Well, I don't understand your example, because C2's value of 20 seems to be
100% of A2-B2, not 97.8%.

But if your C2 value became 19.56 rather than 20, you would get 3 from the
formula =SUMPRODUCT(--(C1:C4/(A1:A4-B1:B4)=98%))
--
David Biddulph


"Tony" wrote in message
...
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......