Calculate remaining items
Hi. I have been struggling with a formula for some time.
I have an excel sheet that needs to calculate the remaining items of a purchase order, by looking at the delivery lines. If the column with the "items" are the same as the purchase (column C & K), then it has to deduct the shipped amount (column D) from the purchased amount (column L) and show the result (column M)
I hope someone can help me
Is this what you meant:
=IF(L3="","",L3-(SUMIFS(D:D,A:A,I3,B:B,J3,C:C,K3)))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi and welcome to the forum.
Maybe in C3 copied down
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks a lot for helping
I seem to be getting an error if I paste these examples into M3, where the result should be displayed.
So in my example, C3 and C6 are shipped items of the purchse in K4 (steelbook) - Shipped lines is 1+4, and purchase is 50 (L4). So in M4 is should say L4-D1-D6 and display the result 45.
Does this makes any sense?
Firstly, who are you talking to?
As far as I can see - my formula was giving 45...
Thank you so much - I must have made an error pasting it in. :D
Cheers.... You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks