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
Check out the Formula Handbook template!