Help needed counting across sheets

08/29/18 Edited 12/09/19

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,




  • Paul NewcomePaul 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)

Sign In or Register to comment.