Hi Community,
I wonder if you could help me. I am not great at formulas, hence why I am here.
I have a spreadsheet, where on Sheet 1, there are 3 columns of data:
Column A = Job Number
Column B = Job Number Sub code
Column C = Hours per sub code
If I want to total all the sub code hours for the job numbers on Sheet 2, to just 1 total figure, per job number, how would I go about it?
Example spreadsheet images attached for ease of what I am looking for.
Thanks in Advance,
Eddy
That could be
=SUMIFS(Sheet1!$C$3:$C$20,Sheet1!$A$3:$A$20,Sheet2!$C5)and drag it down.
Or better to use PivotTable
