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

steveyeoks

New member
Joined
Jul 2, 2013
Messages
1
Reaction score
0
Points
0
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! :)
View attachment 1454
 
Hi
attachment cannot be opened. Post a small sample sheet not a picture - Thx
 
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 ?
 
Back
Top