G
Guest
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(P360<>0, P360,""))}
but not with a filtered list using visable cells only.
Any help appreciated.
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(P360<>0, P360,""))}
but not with a filtered list using visable cells only.
Any help appreciated.