COUNTIFS formula

claude.ngongang80316

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

Mark Cronk

Try:

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

One too many parens at the end.

Mark

claude.ngongang80316

Thanks very much Mark, It worked

Mark Cronk

Try:

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

One too many parens at the end.

Mark

claude.ngongang80316

Thanks very much Mark, It worked

Mark Cronk

Glad you found a solution. Thank you for contributing to the Community.

Mark