COUNTIFS formula

Good Day

I am struggling with the formula below:

=COUNTIFS({IDProjet}, CONTAINS("2020", @cell), {IDProjet}, NOT(CONTAINS("E", @cell)), {DateCD-SAM}, >=DATE(2019, 6, 1), {DateCD-SAM}, <=DATE(2020, 5, 31)))

I am referencing another sheet.

I am having #UNPARSABLE error code. Can't find it.


Please help me.


Cheers,


Claude

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!