Countifs Across sheets

Im to do a countif formula across sheets. I keep getting errors. I'm trying to find "Fire" in one column and the City in another Column. I used

=COUNTIFS({Test FR Data Range 15}, "Fire", {Test FR Data Range 11}, "Arlington")

This formula worked in Excel

=COUNTIFS(C:C,"Fire",D:D,"Arlington") ay help would be appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!