Count If Function


I would like to use the CountIF function to summarize information for a dashboard. I want to count the number of services by client. The column used for service type is mult-select because clients contract for more than one service. For example client 1 may use service A, B, C and client 2 uses B,C,D. I need the formula to count each service ( 2B, 2C, 1A, 1D) I'm having problems finding a formula for this. Can anyone help?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!