In the attached dataset, I am trying to find the most efficient way to get both average weight and volume per location per day. Is there an easier way than doing multiple levels of the "Subtotal" function?

The end result should be:

Location A: | xxx lbs/day | xxx pieces/day
Location B: | xxx lbs/day | xxx pieces/day

Thanks so much!

Seaplane Jack

ExcelForum Avg per Day.xlsx