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.
Try SUMIF.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
I am having difficulty with SUMIF. I have attached an example of what I am trying to achieve.
Last edited by gtudor; 02-13-2012 at 08:43 AM.
Formula in E5 copied down: =SUMIF($H$5:$H$11,C5,$I$5:$I$11)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks