Counting number of times Name appears in multiple contact column

E_Pieper
E_Pieper ✭✭
edited 12/09/19 in Formulas and Functions

I have a column set up as a multiple contact to capture all authors on a journal publication. I would like to use a formula that will count the total number of times a specific name appears in then column. I have tried =COUNTIF({ALL AUTHORS},"John Doe"), but I know it does not yield all of the times the name appears. I doubled checked by using the filter feature.Β 

Also, is the a formula that can be used that would calculate the most number of times a name appears without calculating individually.Like listing authors in aΒ 1st, 2nd, and 3rd type of rating?

I keep these statistics in a separate sheet, so I use the reference option within the formulas.

Thanks.

Beth

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!