Count If Function

milonda.mitchell

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?

boscod35

Hi Mitchell,

Try with the below formula.

=COUNTIFS([Client 1]1:[Client 1]5, HAS(@cell, "A"))

Reference link

CountIF with multiple values in the same cell (same sheet) — Smartsheet Community

Thanks,

Don