Results 1 to 3 of 3

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,463
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi
    attachment cannot be opened. Post a small sample sheet not a picture - Thx

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    772
    Articles
    0
    Excel Version
    2010
    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 ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •