I want to create a sales report summary for each year by division. Below is the data. I would like these totals in a separate worksheet
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Gross Sales Projections by Division / Department | |||||
Division | Department | 2007 | 2008 | 2009 | 3 Year Total |
Electronics | PDA | $2,100,000 | $2,750,000 | $3,750,000 | $8,600,000 |
Electronics | Video | $1,750,000 | $2,500,000 | $3,250,000 | $7,500,000 |
Computers | Laptop | $1,500,000 | $2,100,000 | $2,850,000 | $6,450,000 |
Electronics | Home Audio | $1,500,000 | $1,750,000 | $2,250,000 | $5,500,000 |
Appliances | ******* | $1,450,000 | $1,880,000 | $2,005,000 | $5,335,000 |
Computers | Desktop | $1,750,000 | $1,500,000 | $1,500,000 | $4,750,000 |
Furniture | Family Room | $1,230,000 | $1,500,000 | $1,700,000 | $4,430,000 |
Computers | Video Game | $1,230,000 | $1,260,000 | $1,300,000 | $3,790,000 |
Computers | Accessories | $750,000 | $900,000 | $1,100,000 | $2,750,000 |
Appliances | Laundry | $650,000 | $700,000 | $700,000 | $2,050,000 |
Furniture | Office | $250,000 | $300,000 | $300,000 | $850,000 |
Furniture | Bedroom | $125,000 | $200,000 | $225,000 | $550,000 |
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>