Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtotal question
Hi
I have a large sheet with production data on. Col E contains shift letter, A, B, or C and Col Z contains average producivity. I have =SUBTOTAL(1,Z5:Z800) at the head of col Z so that when I filter col E for each shift the average for that shift is displayed at the top of col Z. Is it possible to have something like: =IF(E5:E800="A",SUBTOTAL(1,Z5:Z800)) =IF(E5:E800="B",SUBTOTAL(1,Z5:Z800)) =IF(E5:E800="B",SUBTOTAL(1,Z5:Z800)) In 3 cells to hopefully display the results for each shift without having to filter col E allowing direct shift to shift comparison. Hope that makes sense Thanks in anticipation Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal Results question | Excel Discussion (Misc queries) | |||
subtotal question? | Excel Worksheet Functions | |||
subtotal question | Excel Discussion (Misc queries) | |||
Subtotal Question | Excel Worksheet Functions | |||
Subtotal question | Excel Worksheet Functions |