How to average subtotal cells in a column with other data
I want to average all the "Total" "ABS Qty" only. The "Total" quantity is a
subtotal formula. In other words, (14+2+2+16+10)/5=8.8
ABS Qty Week
2 23
2 23
2 23
2 23
6 23
14 23Total
2 24
2 24Total
2 25
2 25Total
2 26
8 26
2 26
2 26
2 26
16 26Total
2 28
2 28
2 28
2 28
2 28
10 28 Total
|