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. ...
excel
Formulas and Functions
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