SUMIF
I have a Project Managment
In other Sheet, I want to know the sum of grades that are in two criterias
1. Project owner
2. Drafting Started (Dates between January-March)
Example
Gaby 287
Maryle 200
Sergio
How i can do it?
Best Answer
-
Hey @maryle
I'm happy to help. In your destination sheet (the other sheet), is there a column with the names of project owners?
I'll write the formula assuming the names are in the other sheet, one name per row.
=SUMIFS({Project Management Grades}, {Project Management Project Owner}, [Project Owner]@row, {Project Management Drafting Started}, @cell>=DATE(YEAR(TODAY()), 1, 1), {Project Management Drafting Started}, @cell<=DATE(YEAR(TODAY()), 3, 31))
As this is a cross sheet reference, you remember you cannot simply copy paste this formula in but must create the references within the curly brackets. The names within your curly brackets will be different than mine.
Shout out if you have any trouble or if the formula needs correction
Kelly
Answers
-
Hey @maryle
I'm happy to help. In your destination sheet (the other sheet), is there a column with the names of project owners?
I'll write the formula assuming the names are in the other sheet, one name per row.
=SUMIFS({Project Management Grades}, {Project Management Project Owner}, [Project Owner]@row, {Project Management Drafting Started}, @cell>=DATE(YEAR(TODAY()), 1, 1), {Project Management Drafting Started}, @cell<=DATE(YEAR(TODAY()), 3, 31))
As this is a cross sheet reference, you remember you cannot simply copy paste this formula in but must create the references within the curly brackets. The names within your curly brackets will be different than mine.
Shout out if you have any trouble or if the formula needs correction
Kelly
-
Thank you so much @Kelly Moore!!!
Now is working, exactly as you did it :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!