VLOOKUP with SUM?
I have two sheets - Project Sheet and Timesheet
I need to have the project number from the project sheet looked up on the Timesheet then the costs for the time added together (from multiple rows) to a costing cell back on the project sheet.
Im not familiar with cross sheet formulas so any help would be appreciated.
Thanks!
Best Answer
-
Your brackets are just a little off, and you have some quotes that aren't needed tucked in. Give this a go...
=SUMIFS({Time Tracking Range 4}, {Time Tracking Range 5}, [Job Number]931)
Answers
-
You are going to want something that looks along the lines of...
=SUMIFS({Timesheet Costs Column}, {Timesheet Project Number Column}, "project number of choice")
-
Thanks Paul - Im getting an error. Im building the formula on the Project sheet that includes the Job Number that I need it to look up on the timesheet. Is that correct?
=SUMIFS({Time Tracking Range 4}, {Time Tracking Range 5,"[Job Number]931"})
-
Your brackets are just a little off, and you have some quotes that aren't needed tucked in. Give this a go...
=SUMIFS({Time Tracking Range 4}, {Time Tracking Range 5}, [Job Number]931)
-
Perfect - Thank you so much for your assistance.
-
Happy to help! 👍️
Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.
-
I'm having trouble
this formula only returns the top value, it does not give a total
=SUM(VLOOKUP(Name@row, {KPI Info Range 4}, 6, false))
-
@Dave Bowie Exactly what are you wanting to accomplish?
-
It is a list of daily KPIs that I need running total by name
-
@Dave Bowie Are you trying to count how many times a name shows up?
-
sorry I'm not explaining it very well!
if Joe makes 5 calls today and 7 tomorrow I want the total returned
there are a lot of names on the sheet and i need the rolling total
-
they each input every day
-
@Dave Bowie If Joe makes 5 calls today, will his name be listed 5 times, or will his name be listed once with the number 5 in another column?
-
The names are all in one column and the number of calls made each day are all in another column
so everything is in 2 columns
-
@Dave Bowie Then you will need something like this...
=SUMIFS({Source Sheet Number Column}, {Source Sheet Name Column}, @cell = Name@row)
-
Thank you I will try it
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 467 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!