Forum Discussion
COUNTIF and formulas
So I'm managing an eSport team and I'd like to use the COUNTIF formula to know how many of our players reached a set goal every day. However, each day, the goal varies, because the HP of the enemies varies. Because of that, I have a simple "=B33*0.033" formula, where "B33" is the column where I'll add the enemy Max HP, and "0.033" being 3.3% of the enemy's HP, the goal for everyone to reach a higher tier of reward.
I want to know exactly how many of our players reached the goal, but when I put "B34" in the formula (B2:B30;">B34"), the result comes back as 0, meaning I have to manually edit every single line with the right number, a minor hassle, but something that takes up my time nonetheless. Is there any way to optimize what I want to do, or do I have to keep adding the number instead of the cell?
Thanks.
Hi Luiz
Thanks for the file. I see what you are doing.
Try this variation of the formula:
=COUNTIF(B2:B30,">"&B34)
That should fix your problem.
Cheers
Damien
Could you please upload a sample spreadsheet for us to see?
I know where you are going with this, but if you can provide a sample, we can tweak the spreadsheet and explain the solution.
Cheers
Damien
Here it is, Damien_Rosario
The way I want to do is by having B12 targeting the result of B11, instead of having to manually change the value every day.
Hi Luiz
Thanks for the file. I see what you are doing.
Try this variation of the formula:
=COUNTIF(B2:B30,">"&B34)
That should fix your problem.
Cheers
Damien
