View Single Post
  #1   Report Post  
Amy Yeh
 
Posts: n/a
Default 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.