Sum values in a column using a lookup function

%3CLINGO-SUB%20id%3D%22lingo-sub-1541279%22%20slang%3D%22en-US%22%3ESum%20values%20in%20a%20column%20using%20a%20lookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1541279%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20a%20lookup%20function%20to%20sum%20the%20values%20in%20a%20column.%20The%20formula%20I%20am%20using%20now%20will%20only%20return%20the%20first%20matched%20value%20and%20is%20not%20summing%20all%20of%20the%20values%20with%20the%20lookup%20criteria.%20The%20formula%20I%20am%20currently%20using%20is%3A%20%3DSUM(VLOOKUP(%5B%40Job%5D%2CPRJC!F2%3APRJC!AN848347%2C34%2CFALSE)).%20I%20have%20attached%20pictures%20of%20the%20column%20I%20am%20using%20to%20match%20my%20lookup%20value%20as%20well%20as%20the%20column%20I%20need%20to%20sum.%20I%20have%20also%20tried%20entering%20the%20formula%20as%20an%20array%20function%20but%20that%20did%20not%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20any%20help%20is%20greatly%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1541279%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1541298%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20values%20in%20a%20column%20using%20a%20lookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1541298%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F714531%22%20target%3D%22_blank%22%3E%40Benvett14%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20the%20function%20you%20are%20looking%20for%20is%20SUMIF()%20or%20SUMIFS().%20Please%20refer%20here%20to%20learn%20how%20to%20use%20this%20function%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsumif-function-169b8c99-c05c-4483-a712-1697a653039b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsumif-function-169b8c99-c05c-4483-a712-1697a653039b%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1544565%22%20slang%3D%22en-US%22%3ERe%3A%20Sum%20values%20in%20a%20column%20using%20a%20lookup%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1544565%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F714531%22%20target%3D%22_blank%22%3E%40Benvett14%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20what%20is%20in%20column%26nbsp%3B%3CSPAN%3EPRJC!F%2C%20are%20here%20repeating%20job%20numbers%20or%20unique%20ones%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies

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

@Benvett14 

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