| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for summary from two column
Date Fruits Quantity Fruits 2007 2008
2007 Apple 10 Apple 2007 Orange 56 mango 2007 Mango 48 watermelon 2007 Pineapple 87 orange 2007 Mango 125 strawbery 2007 Citrus 45 citrus 2007 Banana 987 banana 2007 Pineapple 265 grape 2008 Citrus 485 papaya 2008 Banana 698 pineapple 2008 Grape 463 2008 Papaya 216 2008 strawbery 254 2008 Banana 744 2007 Orange 885 2007 Apple 1236 2007 Citrus 1214 2008 watermelon 1546 2008 Apple 8952 2008 Papaya 874 2008 Banana 236 2008 Pineapple 95 2008 Orange 4123 2008 Citrus 236 2007 Banana 216 2008 Mango 956 2008 watermelon 211 2007 watermelon 117 2007 strawbery 261 2007 Apple 112 2008 Grape 234 2008 Grape 278 2007 Banana 678 2008 Apple 330 Hello, Above is the scenario. How to sum the each type of fruits according the the year. How to calculate the sum of apple for 2007 & 2008. this must apply for each type of fruits. Any formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically add a column to summary sheet if another worksheet i | Excel Worksheet Functions | |||
| reference tabs in a summary sheet as column headers | Excel Discussion (Misc queries) | |||
| Column to Row, Summary | Excel Discussion (Misc queries) | |||
| totals sheet- need summary of column of names between sheets | Excel Discussion (Misc queries) | |||
| multi group with summary above with 1 overall summary line below | Excel Discussion (Misc queries) | |||
Threaded Mode
