Countifs to Find Duplicates

I am trying to find if there are multiple requests for a bucket truck within a single day. I am getting an incorrect argument set when I try this formula, but I cannot figure out what is wrong with it.

=COUNTIFS([Date Resource(s) Needed]:[Date Resource(s) Needed], [Date Resource(s) Needed]@row, [Bucket Type]@row, "55' Knuckle Boom")

The formula work when they are separate, but not when they are together.

=COUNTIFS([Date Resource(s) Needed]:[Date Resource(s) Needed], [Date Resource(s) Needed]@row)

=COUNTIFS([Bucket Type]@row, "55' Knuckle Boom")

There are multiple requests per day for various items, but I only want to count the bucket requests so I can do an IF formula to flag when duplicates are found.

Thank you!

Find more posts tagged with

Formulas

Scheduling

Countif

Accepted answers

Jade Boring

That worked! It counted all of the requests for that day even if it wasn't a bucket request, so this was the final version (with a checkbox column)

=IF(AND(COUNTIFS([Date Resource(s) Needed]:[Date Resource(s) Needed], [Date Resource(s) Needed]@row, [Bucket Type]:[Bucket Type], "55' Knuckle Boom") = 2, [Bucket Type]@row = "55' Knuckle Boom"), 1, 0)

Thank you!

All comments

Adam Murphy

Try this:

=COUNTIFS([Date Resource(s) Needed]:[Date Resource(s) Needed], [Date Resource(s) Needed]@row, [Bucket Type]:[Bucket Type], "55' Knuckle Boom")

Jade Boring

That worked! It counted all of the requests for that day even if it wasn't a bucket request, so this was the final version (with a checkbox column)

Thank you!

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.