I can use the SUBTOTAL command with the 101 function to average only visable
cells in a filtered list.
However how can I exclude empty cells from being included in the average?
I can do this with an "array formula", e.g.
{=AVERAGE(IF(P3:P60<0, P3:P60,""))}
but not with a filtered list using visable cells only.
Any help appreciated.