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!
Answers
-
Below should work for you
=COUNTIFS({MATERIAL TRACKING TEMPLATE Range 1},@cell <>"",{MATERIAL TRACKING TEMPLATE Range 4},@cell=[Owner Function]@row)
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!