Formula for counting Stars across multiple sheets

Options
Jessica.Kelly53216
Jessica.Kelly53216 ✭
edited 12/09/19 in Formulas and Functions

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?

Tags:
· Share on FacebookShare on Twitter

Comments

  • sean59916
    sean59916 ✭✭✭
    Options

    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

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!