Countif but only if?
So I am trying to count the number of times a person worked on a specific task. I have various "types", each person might have worked on the task in a different role (Lead SME, SME 2, SME 3), and then I have a check mark whether or not it should be included in the "tally". Ultimately, what I am trying to do would be if the tally column is checked, and the persons name shows up in any of the SME columns, to count the number of TTX's for instance. So if Barnes worked in any capacity on a TTX and the tally check is checked, what is the total number of TTX's? And then repeat that process for the rest of the SME's and types of events.
Help Article Resources
Check out the Formula Handbook template!