abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,429
- Office Version
- 2019
- 2010
- Platform
- Windows
hello
i have two sheets contain data col b is name an b is values and i have sheet output is also names and values what i want add values each name from two sheets to sheet output and sum each name
sheet " MainSheet"
sheet "DataSheet"
sheet "output"
expected result
i have two sheets contain data col b is name an b is values and i have sheet output is also names and values what i want add values each name from two sheets to sheet output and sum each name
sheet " MainSheet"
Book1.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | item | name | result | ||
2 | 1 | ali | 3 | ||
3 | 2 | omar | 0 | ||
4 | 3 | mohammed | 4 | ||
5 | 4 | ahmed | 5 | ||
MainSheet |
sheet "DataSheet"
Book1.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | item | name | result | ||
2 | 1 | ali | 3 | ||
3 | 2 | omar | 0 | ||
4 | 3 | mohammed | 4 | ||
5 | 4 | mohmoud | 5 | ||
DataSheet |
sheet "output"
Book1.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | item | name | result | ||
2 | 1 | ali | 3 | ||
3 | 2 | omar | 2 | ||
4 | 3 | mohammed | 4 | ||
5 | 4 | ahmed | 5 | ||
6 | 5 | mohmoud | 1 | ||
7 | 6 | hassan | 6 | ||
output |
expected result
Book1.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | item | name | result | ||
2 | 1 | ali | 9 | ||
3 | 2 | omar | 5 | ||
4 | 3 | mohammed | 12 | ||
5 | 4 | ahmed | 10 | ||
6 | 5 | mohmoud | 6 | ||
7 | 6 | hassan | 6 | ||
output |