Counting only Meetings that they are part of

[Stephen_IV]

I am trying to count some Virtual Meetings. Along row 1 those are the commitee meetings that they are not part of but can join Virtually if they want. Row 2 are the names of the members. Underneath each member are the Virtual meetings they attended. If the meetings are ones that they are part of then count them, if not don't. Row 12 are the counts I am looking for. Only count the meetings they are apart of. A,B E,G A,B,H,F G,H D Mr A Mr B Mr C Mr D Mr E Mr F Mr G Mr H Committee A Virtual Virtual Virtual Virtual B Virtual Virtual Virtual C D Virtual Virtual E Virtual Virtual Virtual F G Virtual Virtual H Virtual 1 0 1 1 1 0 2 3

 

[Fluff]

How about

=SUM(NOT(COUNTIFS(C1,"*"&$B$3:$B$10&"*"))*(C3:C10<>""))

 

[Stephen_IV]

Yep! That seems to do it. Thnk you very much Fluff!! Much appreciated!!

 

[Fluff]

You're welcome & thanks for the feedback.