Trying to get the average of a price list, when putting in an Autofilter that depends on a column "Segment", I can't get the average of each specific segment. Some of my values include a 0, so I used =sum(range)/countif(range,">0") to get the average without counting the 0.
Unfortunately, I can only get the total average, and not the average of an specific "Segment". Any ideas?
Unfortunately, I can only get the total average, and not the average of an specific "Segment". Any ideas?