Formula with multi select and two fields

Options

I am trying to create a report that shows me June comms, broken out between wireless and wireline, counting how many times the categories occur. I know it's a combo of countifs and contains I just can not figure out the order.. I have tried the following formulas:

=COUNTIFS({Month Column},$[Primary Column]76, {Segment Impact}, CONTAINS([Column2]$75@cell)

=COUNTIFS({Month Column},$[Primary Column]$76,{Segment Type},$[Primary Column]$77 {Segment Impact}, CONTAINS($[Column2]$75@cell))


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!