I am having trouble creating a View I need from a form. I want to count each text input in a row, but am having trouble using this formula:

"Lead MP + JGA + TF + PB + JD + JA + CS + CM + MF + KC + AW + SS + MB + DB + MC + DD + AG + CA"

Only 4 of these fields will ever be selected at once, so an example of what this returns in the formula field I created is:

"NullJGANullNullNullJANullNullNullKCNullNullNullDBNullNullNullNull"

What I want it to show is:

"4"

Is there a formula to do this?

Thanks,

David