Formula with multi select and two fields

danielle romero

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))

Paul Newcome

It looks like you are just missing a couple of commas. You need one after $[Primary Column]$77 and another after $[Column2]$75.