Formula modification help.
I need to modify a formula to pull values of two different cells "SAP PROJECT NUMBER" and "JOB NUMBER" from another "Time Tracking" sheet. I make it work with pulling just one lookup but not two. Below is my formula for one - where to I add the [JOB Number] so it pulls both in this formula?
=SUMIFS({Time Tracking Range 4}, {Time Tracking Range 5}, [SAP Project Number]1383)
Answers
-
Hi Jennie
Just to verify your formula, the {Time Tracking Range 4} should be the column you're trying to sum, like $ or time, for example.
To help ensure that we're referring to the same range, I'll specifically call out the range by name.
=SUMIFS({Time Tracking -the column you're summing}, {Time Tracking SAP Number}, @cell = [SAP Project Number]@row, {Time Tracking Job Number}, @cell=[Job Number]@row)
Be sure to change the ranges in the formula to your real range names.
If this doesn't work, let me know and we can re-work it.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!