95 Percentile Calculation



I need help nesting/modifying formula listed below to calculate (i) Average and (ii) Median (iii) P95

Currently to calculate average, I pull the count in a different cell and divide the SUMIF with total count. Would be helpful if there was an easier way.

=SUMIFS({Weekly Update Range 105}, {Weekly Shop Visit Update 51}, <=[Start Date]74, { Weekly Update 64}, >=[End Date]74, {Weekly Update Range 88}, OR(@cell = "HEAVY/PRSV/LLP", @cell = "MEDIUM", @cell = "LIGHT>500"))

Thank you.

Best Answer