| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I nesting subtotal function within average function in Exc
A B
1 January 2 Clothing & Apparel 44,408 3 Shoes 23,693 4 Jewellery 6,068 5 Cosmetics 29,670 6 Women's Fashions 103,839 (Subtotal) 7 8 Clothing & Apparel 28,600 9 Shoes 21,280 10 Men's Fashions 49,880 (Subtotal) 11 12 TOTAL 153,719 13 Average (Need a Formula on cell: B13 for the two Department) I am grateful to anyone who can find a Formula for the Excel Worksheet. THANKS. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using The Average Function if a cell has NA | Excel Worksheet Functions | |||
| Subtotal function | New Users to Excel | |||
| Average function with If | Excel Worksheet Functions | |||
| Excel's Pivot Table & Subtotal function should have a median fie. | Excel Worksheet Functions | |||
| Using Average function when number is zero | Excel Worksheet Functions | |||
Threaded Mode
