Results 1 to 3 of 3

Thread: COUNTIF Formula

  1. #1

    Red face COUNTIF Formula

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

    I am having a problem with this formula for a simple task. I wish to display a formula that can be used to determine prize money for golf tournaments.I.E
    6 gold medal wins =500 5 gold medal wins and 1 silver =400 and 5 gold medals =300 4 gold medals and 1 silver =200. but i cannot get it to differeniate between 6 golds and 5 gold and 1 silver the same with 5 and 4+1 the formula I have is =COUNTIF(V3,"6")*500 and =COUNTIF(V3,"5"+1)*400 etc etc. So is it possible someone can tell me where I am going wrong.

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Excel Version
    Assume Gold medal is in cell A2, Silver Medal cell is B2, Prize Money cell is C2. Try below formula.

    Attached Files Attached Files

  3. #3
    Hi Sambit
    Many thanks for that just the ticket May you have a great day and a brilliant life
    Kind regards

Posting Permissions

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