Help needed counting across sheets

Jose R Trucios

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 

Paul Newcome

You will need to break it apart. Something along the lines of 

 

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