Hello,
I need to calculate the issues from the warehouse. What is the easiest way to do this? Sum, Sumif, IF I have tried a lot, but unfortunately one does not match the next line.
| REFERENCE | Mon | Tue | Wed | Thu | Fri | |
|---|---|---|---|---|---|---|
| 189 | 189 | 139 | 139 | 139 | 138 | = -51 |
| 43 | 43 | 43 | 43 | 43 | 39 | = -4 |
| 8 | 8 | 8 | 8 | 8 | 8 | = 0 |
| 34 | 43 | 43 | 42 | 42 | 42 | = -1 |
| 85 | 78 | 78 | 135 | 134 | 134 | = 8 |
Thanks for help.
Silvio
[Table format edited by LeroyG]
=SUMPRODUCT(IF(B2:F2<A2:E2;B2:F2-A2:E2;0))
Even if you insist in miss-using a spreadsheet for this task, your table layout is inadequate. Any working inventory system is based on some kind of database.
SimpleInventory_embedded_FB.odb (51.5 KB)
Hallo
=MIN(A2:E2)-MAX(A2:E2)
???
Hello,
that match some parts but not all:
174|167|166|164|274|271 = -13 with min/max = -110
I try
=IF(B2<A2;B2-A2;0)+IF(C2<B2;C2-B2;0)+IF(D2<C2;D2-C2;0)+IF(E2<D2;E2-D2;0)+IF(F2<E2;F2-E2;0)
become -13 but it make trouble with
123|123|123|123|176|176 = -53 with IF = 0, with min/max = -53.
What exactly are you trying to calculate?
Hello,
I have link for the file
These are stock movements, column A is the reference of the previous week and I only want to calculate the stock issues, the stock receipts should be ignored.
PS: Line 9 illustrates the problem with the formula.
Thanks
Why?
You have 150 one day and 66 the next, so you have 84 less, don’t you?
Oh yeah okay so should it work.