Help needed counting across sheets

Hi all,

I am trying to use the count of a symbol across some sheets. I know I can get this information by creating a report but for a more visual presentation, I am looking to get an actual number.

I am currently trying something like this but it's not working:

=COUNTIFS({sheet 1 Range 1}, 1, {Sheet 2 Range 2}, 1)


The symbol is a flag and I just want the count of the ones on across the sheets.

Thank you for any help and direction here,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!