Book1 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | Fruit | Month | Qty | SumofQty | SumofQty | |||||||||
2 | Apples | Jan | 100 | Fruit | Month | Total | Fruit | Month | Total | |||||
3 | Bananas | Jan | 35 | Apples | Jan | 100 | Apples | 138 | ||||||
4 | Grapes | Jan | 41 | Feb | 38 | Bananas | Jan | 35 | ||||||
5 | Oranges | Jan | 62 | ApplesTotal | 138 | Feb | 32 | |||||||
6 | Apples | Feb | 38 | Bananas | Jan | 35 | BananasTotal | 67 | ||||||
7 | Bananas | Feb | 32 | Feb | 32 | Grapes | Jan | 41 | ||||||
8 | Grapes | Feb | 91 | BananasTotal | 67 | Feb | 91 | |||||||
9 | Oranges | Feb | 87 | Grapes | Jan | 41 | GrapesTotal | 132 | ||||||
10 | Feb | 91 | Oranges | Jan | 62 | |||||||||
11 | GrapesTotal | 132 | Feb | 87 | ||||||||||
12 | Oranges | Jan | 62 | OrangesTotal | 149 | |||||||||
13 | Feb | 87 | GrandTotal | 486 | ||||||||||
14 | OrangesTotal | 149 | ||||||||||||
15 | GrandTotal | 486 | ||||||||||||
16 | ||||||||||||||
Sheet1 |