Creating a count using COUNTIF across multiple columns


i would like to count the number of yes's in a column with a corresponding service line in a separate services column

my first column has three drop down options yes/no/NA and i would like to be able to count each one

So for example:

M&E yes = 37

M&E No = 12

M&E NA = 2



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!