Can you use a COUNTIFS formula referencing multiple sheets?

Is it possible to you use a COUNTIFS formula referencing multiple sheets?

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 07/05/20

    Hi Gillian,

    No, the COUNTIFS needs to see how the columns relate to each other to be able to work, so it needs to be within the same sheet.

    That said! You can add multiple COUNTIF or COUNTIFS together. For example:

    =COUNTIF({Status Column Sheet 1}, "Complete") + COUNTIF({Status Column Sheet 2}, "Complete") + COUNTIF({Status Column Sheet 3}, "Complete") ... etc.

    Does that make sense? If you need help building this, it would be useful to see a screen capture of the sheets you're referencing, and an explanation of what it is you'd like to count.

    Thanks!

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!