COUNTIFS Formula with Cross Sheet Reference

Hello,

I am trying to do a countifs formula and I need to reference two columns in another sheet. I have copied the formula I am trying to use below.

=COUNTIFS({2020 Q4 Validations Range 2}, OR(@cell = "Amazon"), {2020 Q4 Validations Range 3}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 3, 31)))

I keep getting #INCORRECT ARGUMENT SET

I would greatly appreciate some help!

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!