(I received an error on my initial post, which is why there are 2.) Anyway,
I tried your formula and it comes up with 1, not 54.

Any other thoughts?

TIA
--
Krista


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Krista" wrote in message
...
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