How do I count one column dependent upon if another column meets a certain criterion?


Apologies, I am having trouble finding the correct syntax for a COUNTIF formula that counts one column only if the other column fulfills the criterion. The criterion is to match a single dropdown selection on one sheet to a given cell in a separate sheet.

For example, in the screenshot below of my metrics sheet, I would like to count the number of activities (referencing the other sheet) that are aligned to rows with Communications (referencing the Owner Function shown = the Communications dropdown selection in the other sheet). I am sure there is an easier solution than the one I have attempted to concoct! Thank you in advance for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!