Formula Question

[Tony]

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......

 

[Tony]

I am using the forumla =SUM(B1/A1) in column "D" and that is how I came up
with 98%. I tried your formula and it returned a number of 4. It should of
returned 2 due to the 1.2% and 5.1% based on below. Let me know if i am way
off track here. I do not need column "D" it is there just as an example.
Thanks for looking in to this....

A B C D E
896 875 21 97.7%
542 500 42 92.3%
896 11 885 1.2%
156 8 148 5.1%

4 (here is where I put in your formula)

 

[Tony]

maybe this will help. row "A" is the membership from the previous month.
Row "B" is adds for the current month. Row "C" is the difference between the
two. So I would like to know what groups have 98% or higher of membership
left, so if the group only has 2% or less left that month then I do not want
to count them.