Forum Discussion
Solved
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 ...
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
- Thanks, that solved my problem.
- HI Luiz
You are very welcome!
Could you please select the answer as Best Response so that others know the solution and to close the loop on this query?
Wishing you all the best with your eSport team!
Cheers
Damien