Sum of data based on certain criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-3072987%22%20slang%3D%22en-US%22%3ESum%20of%20data%20based%20on%20certain%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072987%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wonder%20if%20you%20could%20help%20me.%20I%20am%20not%20great%20at%20formulas%2C%20hence%20why%20I%20am%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%2C%20where%20on%20Sheet%201%2C%20there%20are%203%20columns%20of%20data%3A%3C%2FP%3E%3CP%3EColumn%20A%20%3D%20Job%20Number%3C%2FP%3E%3CP%3EColumn%20B%20%3D%20Job%20Number%20Sub%20code%3C%2FP%3E%3CP%3EColumn%20C%20%3D%20Hours%20per%20sub%20code%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20want%20to%20total%20all%20the%20sub%20code%20hours%20for%20the%20job%20numbers%20on%20Sheet%202%2C%20to%20just%201%20total%20figure%2C%20per%20job%20number%2C%20how%20would%20I%20go%20about%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20spreadsheet%20images%20attached%20for%20ease%20of%20what%20I%20am%20looking%20for.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20Advance%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEddy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sheet%201.png%22%20style%3D%22width%3A%20303px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342679i91F95EC1CA2046B0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Sheet%201.png%22%20alt%3D%22Sheet%201.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Sheet%202.png%22%20style%3D%22width%3A%20492px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F342680i741799323FC1B301%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Sheet%202.png%22%20alt%3D%22Sheet%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3072987%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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

 

Sheet 1.pngSheet 2.png

1 Reply

@Eddy_the_Surveyor 

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

image.png