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
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!