How to SUM corresponding cells from different SHEETS

Good day!

I have a Sheets with hours of each workers in cells in different Sheets ( =projects)

I want to know the SUM of hours for each worker depends on STATUS

Unfortunately my formula works only for specific Column. And for each Column i have to change it

( I will sum my formula for each sheet-project)

Is it possible to make $column somehow for this formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!