I currently have a formula:

=IF(C26="","",LEN(C26)-LEN(SUBSTITUTE(C26,";",""))+1)

But I need to add another function to it somehow and I'm striking out. I
need to include that if C26="-All Clubs",54. I need to place the number 54
into the formula field if the data in C26 is equal to "-All Clubs" yet still
have it count the ";" for all other data that will be input.

Any suggestions? -- THANKS!
--
Krista