Number& type of comms per target audience

Agata Wozniak

Hi ! I am completely stuck. I have columns:

1. Target audience (ie: managers, employees..)
2. Channel (email, meeting ..)

I managed to calculate the number of meetings, but I have no clue how to get to number of meetings per targeted audience. Is this even the right direction?

=COUNTIFS({channel},Meeting,{Target audience},Managers)

Christian G.

Would this works?

=COUNTIFS({channel},"Meeting",{Target audience},"Managers")