Attached please find my spreadsheet.
As you can see I needed subtotals that can be filtered, so I used the subtotal() function.
Unfortunately, some of my rows will sum to Zero (ex: ID 10 and ID 20)
...but since: =SUBTOTAL(1,G2:G30)
...will include the zeros, this throws off my average
I know I can also use the newer AverageIF function, but I am not quite sure if I can adapt this to work if the list is filtered.
In other words, how can I get a filtered average for each Customer, that does not include the zero values?
If anything here is unclear, please let me know...