CountIFS with Multiple Criteria
Good All:
I having a difficult time with my formula counting and meeting all criteria. I want the formula to count how many cells have "Not Started" and have the letter "D". Both have to be met in order to be counted. My current formula returns UPARSEABLE
Here is my formula below:
COUNTIFS({Epicor ERP Data Migration Map Range 3}, "Not Started", {Epicor ERP Data Migration Map Range 12}, "D")).
Thanks
Comments
-
All:
I figured out what I did wrong. No Need to respond.
-
Great, that you solved it!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!