Explanation
The SUM function is the most common option for combining numerical data.
Branch Data
Sirsa
|
Product |
Sales |
|
Keyboard |
4000 |
|
Mouse |
5000 |
|
Monitor |
25500 |
Hisar
|
Product |
Sales |
|
Keyboard |
6000 |
|
Mouse |
4500 |
|
Monitor |
17000 |
Fatehabad
|
Product |
Sales |
|
Keyboard |
4800 |
|
Mouse |
5500 |
|
Monitor |
24000 |
Consolidated Result
|
Product |
Total Sales |
|
Keyboard |
14800 |
|
Mouse |
15000 |
|
Monitor |
66500 |
Steps
- Select destination cell.
- Data → Consolidate
- Choose Sum.
- Add each source range.
- Select appropriate labels.
- Click OK.
Practice
Consolidate the three branch tables using Sum.