Hello everyone
I need to create some kind of a summary for an order.
The orderfile looks like this:
On a second sheet I want to count the number of occurrences of an article, copy some values and give out the total price amount. It should be based on the occurrence of the maker number.
Is this achievable? I'm thankful for every hint, doesn't have to be the solution.
Thanks in advance.
I need to create some kind of a summary for an order.
The orderfile looks like this:
Book1 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Orderday | Ordernumber | Storenumber | Makernumber | Articlenumber | Articlename | Packagecontent | Unit | Price | Amount | Arrivalday | Time | ||
2 | 20200622 | 728001 | 1023 | 45996 | K000141 | Article A | 150 | Single | 25 | 1 | 20200625 | 1 | ||
3 | 20200622 | 729001 | 1032 | 45198 | K000148 | Article B | 60 | Single | 20 | 1 | 20200625 | 0 | ||
4 | 20200622 | 730001 | 1075 | 45996 | K000141 | Article A | 150 | Single | 25 | 1 | 20200625 | 0 | ||
5 | 20200622 | 731001 | 1077 | 45197 | K000147 | Article C | 36 | Single | 20 | 1 | 20200625 | 0 | ||
6 | 20200622 | 731002 | 1077 | 45198 | K000148 | Article B | 60 | Single | 20 | 1 | 20200625 | 0 | ||
7 | 20200622 | 732001 | 1078 | 45996 | K000141 | Article A | 150 | Single | 25 | 1 | 20200625 | 0 | ||
8 | 20200622 | 734002 | 1088 | 45996 | K000141 | Article A | 150 | Single | 25 | 1 | 20200625 | 0 | ||
Sheet1 |
On a second sheet I want to count the number of occurrences of an article, copy some values and give out the total price amount. It should be based on the occurrence of the maker number.
Book1 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Shippingday | Deliveryday | Arrivalday | Makernumber | Articlenumber | Articlename | Packagecontent | Unit | Occurrence | Price | Total Amount | ||
2 | 20200625 | 45996 | K000141 | Article A | 150 | Single | 4 | 25 | 100 | ||||
3 | 20200625 | 45198 | K000148 | Article B | 60 | Single | 2 | 20 | 40 | ||||
4 | 20200625 | 45197 | K000147 | Article C | 36 | Single | 1 | 20 | 20 | ||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
K2:K4 | K2 | =I2*J2 |
Is this achievable? I'm thankful for every hint, doesn't have to be the solution.
Thanks in advance.