SUM & VLOOKUP Formula

[Sarah T Cuttings]

I have the below spreadsheet which has 246 rows, where I would like to sum the values in column I by job type in column J and enter the sum in column Q under the relevant job type. So for example I want the total of all job type C's to be entered into Q4:

If I can ask for your assistance please, that would be great.

Thanks
Sarah

 

[Fluff]

How about

=sumifs(i:i,j:j,p4)

 

[Sarah T Cuttings]

Thanks works great. Thanks Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.