COUNTIF with AND
I've written the statement but am getting a #INCORRECT ARGUMENT SET error.
I'm new to SS, any help is appreciated.
=COUNTIF(AND([Opportunity Risk Path]:[Opportunity Risk Path], [Module Approval Status]:[Module Approval Status], ="Conventional", "Not Started"))
Best Answer
-
=COUNTIFS([Opportunity Bid Due Date]:[Opportunity Bid Due Date], <=TODAY(+10), [Opportunity Risk Path]:[Opportunity Risk Path], "Conventional",[Module Approval Status]:[Module Approval Status], "Not Started")
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Answers
-
Try COUNTIFS instead
=COUNTIFS([Opportunity Risk Path]:[Opportunity Risk Path], "Conventional",[Module Approval Status]:[Module Approval Status], "Not Started")
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined -
Worked, thank you so much.
-
Another quick Q:
I want to combine the following, can you show me how to do it?
=COUNTIFS([Opportunity Bid Due Date]:[Opportunity Bid Due Date], <=TODAY(+10), [Opportunity Risk Path]:[Opportunity Risk Path], "Conventional")
AND
=COUNTIFS([Opportunity Risk Path]:[Opportunity Risk Path], "Conventional", [Module Approval Status]:[Module Approval Status], "Not Started")
-
=COUNTIFS([Opportunity Bid Due Date]:[Opportunity Bid Due Date], <=TODAY(+10), [Opportunity Risk Path]:[Opportunity Risk Path], "Conventional",[Module Approval Status]:[Module Approval Status], "Not Started")
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined -
thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!