A B C D E F D
6000 2 26 Yes 52 4500 0
6000 1 24 Yes 24 4750 0
4500 1 26 Yes 26 5000 0
4500 2 24 Yes 48 5250 0
8500 1 26 Yes 26 5500 0
8000 1 24 Yes 24 5750 0
8000 1 26 Yes 26 6000 0
4750 1 Yes 0 6250 0
6000 1 24 Yes 24 6500 0
5500 1 24 Yes 24 6750 0
5500 3 24 Yes 72 7000 0
5500 2 26 Yes 52 7250 0
5500 2 24 Yes 48 7500 0
5500 2 26 Yes 52 7750 0
4750 1 26 Yes 26 8000 0
need help
trying to sort this couple days now, not very good in excel.
would appreciate if somebody could help.
thank you.
(Need to look in Column A and If its matches F1, and if yes in the same row look for E4) + sum them all together.
Its counting warehouse stock, production made total.
All suggestions are welcome.
6000 2 26 Yes 52 4500 0
6000 1 24 Yes 24 4750 0
4500 1 26 Yes 26 5000 0
4500 2 24 Yes 48 5250 0
8500 1 26 Yes 26 5500 0
8000 1 24 Yes 24 5750 0
8000 1 26 Yes 26 6000 0
4750 1 Yes 0 6250 0
6000 1 24 Yes 24 6500 0
5500 1 24 Yes 24 6750 0
5500 3 24 Yes 72 7000 0
5500 2 26 Yes 52 7250 0
5500 2 24 Yes 48 7500 0
5500 2 26 Yes 52 7750 0
4750 1 26 Yes 26 8000 0
need help
trying to sort this couple days now, not very good in excel.
would appreciate if somebody could help.
thank you.
(Need to look in Column A and If its matches F1, and if yes in the same row look for E4) + sum them all together.
Its counting warehouse stock, production made total.
All suggestions are welcome.