Count the same content of a cell on several sheets

Hello everyone,

I am trying to count the number of cells in about 40 sheets in which "SLF-FP-001 Commercial" appears in a "Green" status.

Is-it possible ?

I know how to do it for a single sheet:

=SUM((COUNTIFS({Sheet 1 Range 1}; "SLF-FP-001 Commercial"; {Sheet 1 Range 2}; "Green")))

Thank you very much for your help.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!