COUNTIF or FIND Functions across multiple sheets



I'd like to try and use the FIND or COUNT function across multiple sheets. Is this possible? My idea is to have a master sheet one directory higher than all my actual data sheets and SUM/COUNT attributes based on similar criteria to the example below


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!