Why is this formula #invalid operation

=COUNTIFS(Flight:Flight, "FSC", [Date of Award]:[Date of Award], >1 / 1 / 2023, [Date of Award]:[Date of Award], <3 / 30 / 2023)

If I put the dates in parenthesizes it yeilds 0 even though I have "FSC" in the Flight column. If I take them away it becomes #invalid.

Find more posts tagged with

Formulas

Accepted answers

Nic Larsen

Try it with the Date function:

=COUNTIFS(Flight:Flight, "FSC", [Date of Award]:[Date of Award], > DATE(2023, 1, 1), [Date of Award]:[Date of Award], < DATE(2023, 3, 30)

All comments

Nic Larsen

Try it with the Date function:

=COUNTIFS(Flight:Flight, "FSC", [Date of Award]:[Date of Award], > DATE(2023, 1, 1), [Date of Award]:[Date of Award], < DATE(2023, 3, 30)

juliesilverio

Hi Ricky,

I believe it is because of your date formatting. I would try the below:

=COUNTIFS([Flight]:[Flight] "FSC", [Date of Award]:[Date of Award], AND(@cell >= DATE(2023, 01, 01), @cell <= DATE(2023, 03, 31)))

Hope that helps!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.