# 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!

«1

• 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"})

• 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

• @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)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!