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