COUNTIFS FORMULA THAT REFERENCES A SEPARATE SHEET THAT ALSO HAS 2 SETS OF CRITERIA
Good morning,
I promise I've looked high and low for this answer! LOL
I have 2 sheets. We'll call them Central and Complete. They are identical. The 2 columns in particular that I'm working with are #1Signing Method (possible cell contents is either Paper/Esign) #2Month Opened (options are numbers 1  12). The goal is to extract a count of instances of "Esign" that ALSO have a 2 in the Month column (for February). We're really just trying to monitor how many accounts are Esigned vs. Paper signed on a month to month basis. I'm building the formula in the Sheet Summary area. My formula works perfect up until the part where it ''points to' the criteria of requiring that a '2' be in the Month column for the data on the referenced sheet.
Here's what I'm doing:I start off in the Complete Sheet Summary and build out the first formula, which extracts the correct number from JUST that sheet, no problem. But then I need to be able to ADD TO that formula, the same data from the Central sheet and I am pulling my hair out trying to troubleshoot what I'm doing wrong. Once I click the ReferenceAnotherSheet link, can I not select 2 columns at the same time to be my range? Is that it?
This is what the current formula looks like:
=COUNTIFS([Signing Method]:[Signing Method], "Esign", [Month Opened]:[Month Opened], 2)+COUNTIFS({CENTRAL 1},[Signing Method]:[Signing Method], "Esign", [Month Opened]:[Month Opened], 2)
I get an IncorrectArgumentSet error :(
Any light you can shed is greatly appreciated!
Shelley
Answers

Maybe use the formulas in separate cells, and add those cells together in another column?
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!