Formula Question

  • Thread starter Thread starter Tony
  • Start date Start date
T

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......
 
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)
 
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.
 
Back
Top