COUNTIF cells match in different sheets

Options

I am struggling to get a count if cells match when referencing different sheets. I am working on "Sheet 0" and want to check how many cells in "Sheet 1" match cells in "Sheet 2" for one column.

Here is my formula: =COUNTIFS({Sheet 1 column}, ="{Sheet 2 column}")

have also tried without parenthesis. I currently get a 0 count which i know is false.

Any ideas would be appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!