Dear mrexcel community,
I'd like to share my first question in the forum with you.
What I am trying to do is summing up different item quantities by week and put in sheet 2:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Sheet 2
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>So basically I need a formula to come up with the numbers in red.
Is this possible?
I'd really appreciate your help..
Thanks a lot!
tim
I'd like to share my first question in the forum with you.
What I am trying to do is summing up different item quantities by week and put in sheet 2:
Sheet 1 | |||||
desciption | Qty | Date | |||
Item 1 | 5 | 1/01/2018 | |||
Item 1 | 10 | 2/01/2018 | |||
Item 2 | 15 | 13/01/2018 | |||
Item 1 | 50 | 4/04/2018 | |||
Item 1 | 20 | 20/01/2018 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Sheet 2
desciption | Week1 | Week2 | Week3 | Week4 | |
Item 1 | 15 | 20 | |||
Item 2 | 15 | ||||
Item 3 | |||||
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Is this possible?
I'd really appreciate your help..
Thanks a lot!
tim