Adding third range/criterion causes #INCORRECT ARGUMENT SET

I am trying to add a third range/criterion to functioning formula. I added ", {2021 Resource Tracker Location}, "Lead"" and it causes #INCORRECT ARGUMENT SET. I have tried several other ideas without success. I probably am just over thinking it and it is something simple.

=COUNTIFS({2021 Resource Tracker Appraiser Text}, FIND(Appraiser@row, @cell) > 0, {2021 Resource Tracker Range 1}, AND(@cell >= DATE(2021, 3, 16), @cell <= DATE(2021, 3, 31)), {2021 Resource Tracker Location}, "Lead")

Thank you for your time.

Find more posts tagged with

Accepted answers

Heather Duff

Hi @Clifton Gillette ,

Try making it

@cell="Lead")

at the end. Let me know if it works!

Best,

Heather

Clifton Gillette

Thank you Heather. That did it.

All comments

Heather Duff

Hi @Clifton Gillette ,

Try making it

@cell="Lead")

at the end. Let me know if it works!

Best,

Heather

Clifton Gillette

Thank you Heather. That did it.

Heather Duff

Fantastic! Glad it worked.

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.