CountIFS with Multiple Criteria

Tony Barthelemy
Tony Barthelemy ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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")).




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!