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.
Best Answer
-
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")
Answers
-
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")
-
That was it. Thank you so much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!