How to vlookup the sum of various cells with the same identifier in one column

Hi guys,

i am looking for a function that allows me to Vlookup the sum of different values in one column based on the same identifier (ID). Attached yo can find an example of the table and the desired output.

I know that i can vlookup the sum of different values with =sumproduct(vlookup)... if the values are in a row (horizontally). But how do i do it if those values are in a column?

Any help is appreciated!
Thanks so much.


example.PNG

Hi,

Welcome

please check with function SUMIF

You can use SUMIF function.

=SUMIF(col_ID,"1234",col_Sales)

You can use this:

=SUMIF(Sheet1!A:A,C1,Sheet1!B:B)

where C1 on the sheet with the formula contains the ID 1234.

Hope this helps.

Pete

Hi all,

thanks for your answers.
Do you know how to combine the sumif funtion with a vlookup?

Best,
Rahel

In what way do you want to combine them?

Pete

Hi Pete, my thinking mistake. sorry! The sumif is all i need. Thanks a lot guys for your help!!