Sum values in a column using a lookup function

[Benvett14]

I am trying to use a lookup function to sum the values in a column. The formula I am using now will only return the first matched value and is not summing all of the values with the lookup criteria. The formula I am currently using is: =SUM(VLOOKUP([@Job],PRJC!F2:PRJC!AN848347,34,FALSE)). I have attached pictures of the column I am using to match my lookup value as well as the column I need to sum. I have also tried entering the formula as an array function but that did not help.

Thanks, any help is greatly appreciated!

[#2]

Hello @Benvett14,

I think the function you are looking for is SUMIF() or SUMIFS(). Please refer here to learn how to use this function:

https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b

[#3]

@Benvett14 

And what is in column PRJC!F, are here repeating job numbers or unique ones?