I have some data in column F that I want to average. The data needs to be filtered so that I can remove some of the data and change the average.
=subtotal(1,F3:f20) works great but it includes the zeros and is bringing the average down. How can I easily tell the formula to remove all zeros and still be able to filter the data?
Bookmarks