How to sum EstCost if Job = "100000"?
Hi,
We actually have Office 365 but this was not an option in the registration screen. I'm on Windows 10.
I have some raw data in a spreadsheet, sheet is named "JobCost", that has these columns:
Job, EstCost, ActCost, EstHours, ActHours
The Job column is actually a text field and is formatted that way in Excel. This is actually fake data from a database and the job number is a text field in the database as well.
There are multiple entries/rows for each job on this sheet "JobCost". Like this:
Job Job part Start date EstHours ActHours EstCost ActCost
100000 01 1/1/2021 1.2
100001 01 1/2/2021 2.3
100001 01 1/3/2021 1.2 35
100001 01 1/4/2021 1.3 40
100001 01 1/5/2021 35
100002 01 1/6/2021 30
100001 01 1/7/2021 5.5
100001 01 1/8/2021 1.2
On another sheet called "SumByJob" I have these columns, but I want one row per job to sum all EstHours from the sheet "JobCost":
Job, EstHours, ActHours, EstCost, ActCost.
I want to sum all EstHours from the JobCost sheet, for one job and put it on the sheet "SumByJob" under the EstHours column. I've looked at the VLOOKUP functions and that doesn't look right. I've looked at SUMIF and it is not working for me.
I'm not used to doing this sort of thing in Excel. Can someone help me out please? I have attached my Excel file for you to look at.
Thank you!
EDIT: Results should be this:
Job EstHours ActHours EstCost ActCost
100000 1.2
100001 7.8 3.7 35 75
100002 30
|