countif formula

[guitarman]

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

 

[Nebu]

Hi:

Use the following formula, assuming your Medal data is from range A2:A7

=IF(COUNTIF($A$2:$A$7,"Gold")=6,"£500",IF(AND(COUNTIF($A$2:$A$7,"Gold")=5,COUNTIF($A$2:$A$7,"Silver")=1),"£400",IF(COUNTIF($A$2:$A$7,"Gold")=5,"£300",IF(AND(COUNTIF($A$2:$A$7,"Gold")=4,COUNTIF($A$2:$A$7,"Silver")=1),"£200"))))

Thanks

 

[guitarman]

Hi:

Use the following formula, assuming your Medal data is from range A2:A7

=IF(COUNTIF($A$2:$A$7,"Gold")=6,"£500",IF(AND(COUNTIF($A$2:$A$7,"Gold")=5,COUNTIF($A$2:$A$7,"Silver")=1),"£400",IF(COUNTIF($A$2:$A$7,"Gold")=5,"£300",IF(AND(COUNTIF($A$2:$A$7,"Gold")=4,COUNTIF($A$2:$A$7,"Silver")=1),"£200"))))

Thanks

Hi There Nebu
Many thanks for that it is just the ticket again much appreciated have a great day
Mike