Formula for counting Stars across multiple sheets

Jessica.Kelly53216

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?

sean59916

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