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

Lauren MB

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!

Leibel S

@Lauren MB

Below should work for you

=COUNTIFS({MATERIAL TRACKING TEMPLATE Range 1},@cell <>"",{MATERIAL TRACKING TEMPLATE Range 4},@cell=[Owner Function]@row)

Lauren MB

Thank you for replying! This formula returned "#UNPARSEABLE" when I tried it, but I think I found a separate workaround. I appreciate your thinking though - much appreciated!