PLEASE HELP!! COUNTIF function for counting specific value show zero

[steveyeoks]

Hi guys, i desperately need help on this. I have a report to submit by WED! Any help is appreciated!

Attached is the picture to give a clearer idea.

I'm trying to to do monte carlo simulation. I have one column created (G21 to G1020) and the another column (F) is the specific value that will occur in the range (G21 to G1020). Lastly, i did a Countif function with range (G21 to G1020) and criteria is the specific value from the the column (F). Formula: =COUNTIF($G$21:$G$1020,H21)

Please tell me what did i miss out. Really appreciate your help with this. Thank you!
Attachment 1454

[Pecoflyer]

Hi
attachment cannot be opened. Post a small sample sheet not a picture - Thx

[Hercules1946]

Hi
It is too late for your deadline, but I noticed that you say that your criteria is Col F, and you've specified col H as the criteria in your COUNTIF formula. What happens if this is amended to col F ?