Hi expert:
Have a problem need help from you all. I need to sumvalue of T3+ T4 on January, February that i show at sheet1 of the worksheet. And i need to display the output that show as like sheet2. When the data field [product] is same, it will sumvalue of the T3 and T4.
[remark: 1. some of product don't have T3 or T4.
2. The value of January and February maybe is empty.]
The output that i need.
Have anyone can provide the solution? Thanks a lots
Regards,
Andy
Have a problem need help from you all. I need to sumvalue of T3+ T4 on January, February that i show at sheet1 of the worksheet. And i need to display the output that show as like sheet2. When the data field [product] is same, it will sumvalue of the T3 and T4.
[remark: 1. some of product don't have T3 or T4.
2. The value of January and February maybe is empty.]
Book.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Product | Req | Jan | Feb | |||
2 | aaa | reque | 1 | 1 | |||
3 | aaa | T3 | 2 | 1 | |||
4 | aaa | T4 | 1 | ||||
5 | bbb | reque | 0 | 1 | |||
6 | bbb | T3 | 0 | 0 | |||
7 | ccc | reque | 1 | 1 | |||
8 | ccc | T3 | 0 | 1 | |||
9 | ccc | T4 | 1 | 1 | |||
10 | |||||||
Sheet1 |
The output that i need.
Book.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Product | Req | Jan | Feb | |||
2 | aaa | reque | 1 | 1 | |||
3 | aaa | T3+T4 | 2 | 2 | |||
4 | bbb | reque | 0 | 1 | |||
5 | bbb | T3 | 0 | 0 | |||
6 | ccc | reque | 1 | 1 | |||
7 | ccc | T3+T4 | 1 | 2 | |||
8 | |||||||
Sheet2 |
Have anyone can provide the solution? Thanks a lots
Regards,
Andy