Forum Discussion

Benvett14's avatar
Benvett14
Copper Contributor
Jul 23, 2020

Sum values in a column using a lookup function

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!

excel
Formulas and Functions

2 Replies

Sort By
  • PReagan's avatar
    PReagan
    Bronze Contributor
    Jul 23, 2020

    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

Resources