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?
Answers
-
Not sure if I am interpreting your question correctly.
What I have done is copy the formula into each column and change the column name in the formula. If possible, I convert it to a column formula. If not, then I drag the formula down.
=SUMIFS({Airship_Finished}, {Airship Team}; Team@row) and so forth.
Meg Young
mmyoungconsulting@gmail.comCertified Core Product, Project Management, and System Admin.
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks! -
Hi Meg Y
Yes, your answer works if you change formula for each column. I want to drag formula to both, column and row.
I’m lazy and want to know, is it possible…
without any reports and so on. Just like in Excel. A1 + A1. And drag
-
Meg Young
mmyoungconsulting@gmail.comCertified Core Product, Project Management, and System Admin.
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks! -
Also, i have this idea but it doesnt` work
To sum INDEX
=INDEX({Airship Status}, MATCH (TEAM@row, {Airship Team}, 0)) + the same for another projects
It doesn`t work right now.. not sure why
-
Hi @Volodymyr L
There currently isn't a way to make a cross-sheet formula range dynamic as you drag it across columns. The simplest way to do this would be to create one new cross-sheet reference per column to SUM. This would also make it easier to edit any of the formulas down the line!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!