Cross-sheet COUNTIFS

System

This discussion was created from comments split from: Using Countifs with multiple references to other sheets.

Ed Gadd

The following formula works on the original data sheet

=COUNTIFS(PENS:PENS, "RED", STATUS:STATUS, "SOLD")

However I'd like calculate this on another sheet. Should I create two reference data ranges? And how do I add this into the formula please? What would the formula look like?

Paul Newcome

You would need to create cross sheet references for each range / column.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references