VLOOKUP with SUM?

Jennie Jones

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!

Paul Newcome

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)

Paul Newcome

You are going to want something that looks along the lines of...

=SUMIFS({Timesheet Costs Column}, {Timesheet Project Number Column}, "project number of choice")

Jennie Jones

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

Paul Newcome

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)

Jennie Jones

Perfect - Thank you so much for your assistance.

Paul Newcome

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.

Dave Bowie

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

Paul Newcome

@Dave Bowie Exactly what are you wanting to accomplish?

Dave Bowie

It is a list of daily KPIs that I need running total by name

Paul Newcome

@Dave Bowie Are you trying to count how many times a name shows up?

Dave Bowie

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

they each input every day

Paul Newcome

@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?

Dave Bowie

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

Paul Newcome

@Dave Bowie Then you will need something like this...

=SUMIFS({Source Sheet Number Column}, {Source Sheet Name Column}, @cell = Name@row)

Dave Bowie

Thank you I will try it