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

SPRINGBOK

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

Jeff Reisman

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