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.
    Guitarman

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

    =IF(AND(A2=6,B2=0),500,IF(AND(A2=5,B2=1),400,IF(AND(A2=5,B2=0),300,IF(AND(A2=4,B2=1),200,0))))
    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
    Mike

Posting Permissions

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