How to SUM corresponding cells from different SHEETS
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
Check out the Formula Handbook template!