abdelfattah
Well-known Member
- Joined
- May 3, 2019
- Messages
- 1,430
- 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 | |||||
