Formula for counting Stars across multiple sheets

04/30/19 Edited 12/09/19

I am trying to count the Stars that are checked across multiple sheets.  I can’t seem to get a formula to work.  Would anyone know?

Popular Tags:

Comments

  • Hi Jessica -

    How many sheets are you checking? It's rather manual, but I've attached an example with 2 different formulas: 

    - Detailed, referencing each sheet =COUNTIF({Sheet1}, 1)

    - Summarized, =SUM(COUNTIF({Sheet1}, 1), COUNTIF({Sheet2}, 1))

    You will need to reference the column in each sheet. 

     

    I hope this helps?

     

    Sean

    2019-05-01_12-25-39.jpg

    2019-05-01_12-25-02.jpg

    2019-05-01_12-23-54.jpg

    2019-05-01_12-23-31.jpg

Sign In or Register to comment.