Return a number count based on criteria within two separate columns

I'm seeking a formula that will return a value if a certain criteria is met in one column and another criteria in another column.
For example, I'm trying to count how many items there are that have "Medium (within next FY to 3 yrs)" with a status of "Green". I'm trying to report this in Sheet Summary. Thank you!
Best Answer
-
Hi @Shane Sorensen ,
Try:
=COUNIFS([Timeframe]:[Timeframe], "Medium (within next FY to 3 yrs)", [Status]:[Status], "Green")
Standard COUNTIFS syntax should work for this.
Good luck.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Shane Sorensen ,
Try:
=COUNIFS([Timeframe]:[Timeframe], "Medium (within next FY to 3 yrs)", [Status]:[Status], "Green")
Standard COUNTIFS syntax should work for this.
Good luck.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hi Shane, Glad it worked. Thanks for using the Community.
Be Well,
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!