Counting a specific character

[support_nz]

I want a formula to count "," in a row. The spreadsheet records individuals wins over the years in different events. The events are in columns and each individual is a row. Their wins are recorded as a year for example if they won an event this year the value in the event column in their row would be 15, The "," is use to differentiate between years. So if a person wins the same event in 1992 and again in 2013 the cell value would be 92,13,

One of the column shows how many wins each person has over all events, so I need a formula to add up all the ",". In the example below this person has won 5 events.

Fours Triples Pairs Singles Fours Triples Pairs Singles Fours Pairs
99, 98,00, 00,06,

thanks for all help

[JohnTopley]

Try

=LEN(A2)-LEN(SUBSTITUTE(A2,",",""))

[Jonmo1]

Not sure I understand the logic of your overall goal..

But you can count how many commas are in a single cell like this

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

[support_nz]

Thanks for the quick response, I had already tried something similar but keep getting errors. The amount of commas I want to count is from columns F to O not a single cell. I tried your suggestion with this formula below but get an error message. "You have entered to many arguments for this formula"

=LEN(F30:O30)-LEN(SUBSTITUTE(F30:O30),",",""))

[support_nz]

I also tried this

=LEN(F30:O30)-LEN(SUBSTITUTE(F30:O30,",",""))

The value in the cell is #VALUE!

[Jonmo1]

Try

=SUMPRODUCT(LEN(F30:O30)-LEN(SUBSTITUTE(F30:O30,",","")))

[support_nz]

Thanks for the reply Jonmo1

Working perfectly, brilliant!