Hi,
I am trying to calculate the average of a dataset which has filters, AND ignore any datapoints that are 0. Usually I would simply use Avergeif and specify the numbers to be >0, however this does not work for filtered data. Alternatively the subtotal function does not have Averageif as an option.
Can anyone help?
Bookmarks