Attempting COUNTIF(AND

Hello! I am trying to create a formula to count inspections created by a specific driver each month. I keep getting "Incorrect Argument". Do I need to separate the columns differently?

=COUNTIF(AND({Vehicle Inspection Checklist Management Sh Range 3}, IFERROR(MONTH(@cell), 0) = 1, {Vehicle Inspection Checklist Management Sh Range 2}, "John Smith"))

Any guidance would be a huge help! Thank you!

Find more posts tagged with

Accepted answers

All comments

Mark Cronk

Hi @Kim Fearno ,

Try:

=COUNTIFS({Vehicle Inspection Checklist Management Sh Range 2}, "John Smith"), {Vehicle Inspection Checklist Management Sh Range 3}, IFERROR(MONTH(@cell), 0) = 1)

Work?

Mark

Kim Fearno

Thanks Mark,

Unfortunately It is now giving me an #UNPARSEABLE error.

I got the formulas to work separately:

=COUNTIF({Vehicle Inspection Checklist Management Sh Range 2}, "John Smith")

=COUNTIFS({Vehicle Inspection Checklist Management Sh Range 3}, IFERROR(MONTH(@cell), 0) = 1)

Just can't seem to get them to work together...

Mark Cronk

There was an extra paren. Try:

=COUNTIFS({Vehicle Inspection Checklist Management Sh Range 2}, "John Smith", {Vehicle Inspection Checklist Management Sh Range 3}, IFERROR(MONTH(@cell), 0) = 1)

Mark

Kim Fearno

Back to "Incorrect Argument" :(

Mark Cronk

Hi again Kim,

You need to check your ranges. Best to recreate them. They should be the entire single column you want examined. Additionally, confirm that column this formula is in and your Range 2 are formatted as text/number and that Range 3 is formatted as date.

Work this time?

Mark

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.