Using VLOOKUP to sum values cells vertically

[epresent]

Hi I have a data set where each order ID has different settlement values. There are duplicate order ids with different settlements amounts which need to be summed

order id	net settlement
OD105630099701460000 <tbody> </tbody>

<tbody>
</tbody>

In tab 2

order id	settlement
OD105630099701460000	945
OD105630099701460000	-900
OD105630099701460000	25

<tbody>
</tbody>

Need to lookup the order id's and sum them under net settlement

Could someone please help

 

[bhos123]

you can use Sumif function. C2=SUMIF(A:A,A2,B:B)

 

[BGY23]

Assume your data is in A1 to B4 and the order number you want to sum is in C1 then

Sumif($a$2:$A$4,C1,$B$2:$B$4)

If you have lots of them and they change regularly cobsider a pivot table.

 

[otisvillain]

I agree with bhos123, use a SUMIF

 

[epresent]

Hey BGY thannx a ton for the quick answer. For some odd reason when i use the sumif it takes the first value and it does not add the rest of the values

 

[BGY23]

Check the other order numbers are exactly the same as the norder number in C1. Ensure there are no leading, trailng spaces. The order number in C1 and in the table MUST be exactly the same for it to work. Extra spaces, digits, numbers and it will not work properly

 

[epresent]

Hi I am using this formula
=SUMIF(payments!$A$1:$A$780,'flipkart sales april 2016'!A23,payments!$X$1:$X$780)

i have sorted the data in the other worksheet according to order numbers, hence all the duplicate order numbers are one below the other

 

[epresent]

The formula just takes the first value. Is there an alternative method, or am I doing something wrong

 

[epresent]

anybody there that can help? Please