| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weighted Average Within Sort/Subtotal | Excel Discussion (Misc queries) | |||
| Average of cells in a column | Excel Worksheet Functions | |||
| SUBTOTAL function to average column without blanks | Excel Worksheet Functions | |||
| how can I average more cells only in a column by a criteria? | Excel Worksheet Functions | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
Threaded Mode
