CountIFS with Multiple Criteria

Tony Barthelemy

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

Tony Barthelemy

All:

I figured out what I did wrong. No Need to respond.

 

Andrée Starå

Great, that you solved it!

Best,

Andrée