COUNTIF & ISDATE FUNCTION

Good Afternoon All,

I hope you are stating safe in this winter weather. I have a formula but to no avail I am getting unparseable.

I want my COUNTIFS function to count only if there is a date in column (DEACTIVATE TIMESTAMP YR 5) = ANY DATE

and

count only if the specific criteria from on column (DEACTIVATE TIMESTAMP YR 5) = CHARM

MY FORMULA:

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

MY COLUMNS:

Find more posts tagged with

Non-profit

Formulas

Accepted answers

Paul Newcome

@NCNWIncData The error is coming from the extra closing parenthesis at the end of your formula. You have one too many.

All comments

amarkumar

@NCNWIncData Your UNPARSEABLE error is because COUNTIFS criteria can’t use ISDATE(@cell ) like that.
Use “not blank” for the date/timestamp column:
=COUNTIFS([DEACTIVATE TIMESTAMP YR 5]:[DEACTIVATE TIMESTAMP YR 5], "<>", [Abbreviated Org Name.]:[Abbreviated Org Name.], "CHARM")

If that column can contain non-date text and you truly need “valid date only,” you’ll need a helper column like =IF(ISDATE([DEACTIVATE TIMESTAMP YR 5]@row ), 1, 0) and then count where helper = 1.

Paul Newcome

@amarkumar You can use the ISDATE function in a COUNTIFS. I do this regularly. Please double check your source(s) before posting.

Paul Newcome

@NCNWIncData The error is coming from the extra closing parenthesis at the end of your formula. You have one too many.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.