Formula Formatting Question

Please forgive the newbie question but I am trying to get a count of services performed across columns from two sheets with a specific criteria:

Current Tracker
Tracker Archive

The formula I am using returns INCORRECT ARGUMENT SET

COUNTIFS({Request Tracker Range 1}, "Edit Seat", {Request Tracker Archive Range 2}, "Edit Seat")

I am sure that I am not bracketing the argument correctly but all my attempts at variation return the same error.

Any hints are appreciated.

Find more posts tagged with

Accepted answers

Paul Newcome

The syntax is correct. The issue is that the ranges are not the same size on the same sheet. What you will need to do is use two separate COUNTIFS and add them together.

=COUNTIFS({Request Tracker Range 1}, "Edit Seat") + COUNTIFS({Request Tracker Archive Range 2}, "Edit Seat")

All comments

Paul Newcome

The syntax is correct. The issue is that the ranges are not the same size on the same sheet. What you will need to do is use two separate COUNTIFS and add them together.

=COUNTIFS({Request Tracker Range 1}, "Edit Seat") + COUNTIFS({Request Tracker Archive Range 2}, "Edit Seat")

Todd Smelser

That was it. Thank you so much!

Paul Newcome

Happy to help. 👍️

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.