I am attempting to find the average, median and 75th percentile in a list of data that I have, but I would like to exclude zeros from the calculations. Column D has various years (2012,2013,2014) and Column E has salaries. Essentially, I am trying to develop formulas that do these three things:
Are there criteria formulas that can accomplish this? or are there formulas I could run if I first filter the data by year?
- "If the year is 2012, find the average of the salaries, but do not include zeros"
- "If the year is 2012, find the median of the salaries, but do not include zeros"
- "If the year is 2012, find the 75th percentile of the salaries, but do not include zeros"
Are there criteria formulas that can accomplish this? or are there formulas I could run if I first filter the data by year?
Last edited: