Formula Help!!

[dkflameboy]

I've created a spreadsheet for my kids football tournaments and I'm managing who has paid and how much they owe. There are four tournaments in cells C2, D2, E2 and F2 with a total payment in cell G2. Names start from row 3. Each tournament costs £5 to enter and I want to put a simple Y in cells C3, D3, E3 and F3 and have cell G calculate how much the total will be, so if cells C3, D3 and F3 contain a Y cell G will return £15.

How do I go about this?

Thank you

 

[Gerald Higgins]

Perhaps something like . . .
=countif(C3:F3,"Y")*5

 

[dkflameboy]

Perhaps something like . . .
=countif(C3:F3,"Y")*5

Worked like a charm, thank you.