Vlookup? Trying to add up all values of a duplicate entry.

[gtudor]

Hi,

I am trying to work out a formula so that I can see what the quantity recieved is compared to our purchase order qty. Currently we have a system that adds up the total items on our purchase order and a seperate sheet to book the goods in.

Where the system breaks down is when purchase orders are part delivered there becomes 2 identical entries (PO number) and my formula only calculates the latest receipt.

Is there a formula that can add up all of the values for these duplicate entries and give an answer to the amount received in one cell?


Thanks in advance for your help.

[Domski]

Try SUMIF.

Dom

[gtudor]

I am having difficulty with SUMIF. I have attached an example of what I am trying to achieve.

[Domski]

Formula in E5 copied down: =SUMIF($H$5:$H$11,C5,$I$5:$I$11)

Dom

[gtudor]

I think that has done it thank you. I will have a play as the data I am trying to fetch is in seperate files.