Footy Tipping 'COUNTIF' Formula Help

[Specky]

I'm setting up a spreadsheet for footy tipping I'm running.

I'm almost done with all the formulas I need to count the winners, but theres one small problem.

It's in Excel like this

Specky | STK | ESS | RIC | FRE | MEL | SYD | BRI | CAR | Round Total | Overall Total

What I need is in the round total box, it displays the number of picks I got right. So say I got STK, FRE, SYD and CAR right, I need the forumula to count all those picks and give me a total of 4. Currently I have the forumula: =COUNTIF(B2:I2,"STK"), which counts the STK as 1. I can't figure out how to make it so FRE, SYD, CAR and STK are all counted.

If theres a way to do this, please help me, it's much appreciated.

[rylo]

Hi

How does it know which items you got right?

rylo

[Specky]

Hi

How does it know which items you got right?

rylo

With the =COUNTIF(B2:B6,"STK").

I was hoping of a way to maybe be able to put ,"STK","CAR") or something but it doesn't work.

[rylo]

Hi

What is the criteria that determined that STK was a winner? You know it is a winner, but how? Did it get the biggest number, or the closest to the right answer? What are the rules that determine the item / thing / whatever is a winner?

Once you define your rules for winning, are any of those details available on the sheet?

Maybe you should post an example workbook, and detail how the winners are determined.

rylo

[Dan27]

Hello

The following works

{=SUM(($A$1:$A$10="FRE")+($A$1:$A$10="STK"))}

It needs to be an array formula which can be done by entering the formula and then hit Ctrl, Shift + Enter