COUNTIFS & ISDATE FORMULA

Question

Good Afternoon,

Hope you are safe in this winter weather.

MY FORMULA is unparseable:

=COUNTIFS([DEACTIVATE TIMESTAMP YR 5]:[DEACTIVATE TIMESTAMP YR 5], ISDATE(@cell ), [Abbreviated Org Name.]:[Abbreviated Org Name.], "CHARM"))

The formula should count ONLY if any date is appears in column DEACTIVATE TIMESTAMP YR 5 = ANY DATE

and

counts if the specific criteria CHARM appears in column ABBREVIATED ORG NAMES =

REFERENCE COLUMNS:

Thanks,

NCNW, Inc.

Paul Newcome · Accepted Answer

Try removing the last closing parenthesis at the end of the formula. You have one too many.