(SOLVED) PLEASE HELP!! COUNTIF function for counting specifice value only shows 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!

COUNTIFERROR001_zps05c2252a.jpg

Hi steveyeoks,

Welcome to the forum

In your description you have described about Column-F but in your formula there is no reference for Column-F

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you

Please refer Post #3 and post a sample workbook for our better understanding

It's surprising my signature don't catch your eyes Find below the detailed instruction...

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

What is your expected result for J21 cell and how you do the matches and get that result?

I already gone through all the things which you described it in Post #10 but still expecting the answer for my request in Post 9

The problem is the Column-J only shows "zero" value which is weird as I can visibly see results.

What is the cells in which you are seeing the match? still what is the expected result of J21 cell?

Originally Posted by steveyeoks

Take a look at H:72, the value there is 4.51.The value should not be 0 because in G:32, "4.51" appeared once.

Still it's unclear to me how you are matching these two..

H72 Cell Value
4.51

G32 Cell Value
5.51

hi steveyeoks. you used RAND in column B, so we are not going to be seeing the same things. format your cells in column H to show like 18 decimal places. you'll see that halfway through, it goes haywire. it has got to do with Excel using binary numbers. you can google that. so you should probably use this formula in H22:
=ROUND(H21+0.01,2)

For your additional info your file is in MANUAL CALCULATION MODE.