Help needed counting across sheets
Options
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,
Best,
Jose
Comments
-
You will need to break it apart. Something along the lines of
=COUNTIFS({sheet 1 Range 1}, 1) + COUNTIFS({Sheet 2 Range 2}, 1)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!