# COUNTIFS FORMULA THAT REFERENCES A SEPARATE SHEET THAT ALSO HAS 2 SETS OF CRITERIA

Options
✭✭✭

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

• ✭✭✭✭✭✭
Options

Maybe use the formulas in separate cells, and add those cells together in another column?

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!