Can you use a COUNTIFS formula referencing multiple sheets?

Gillian Pritchard

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

Genevieve P.

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