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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!