How to Count Quartiles in Excel. ... and then determine which quartile you want to calculate. ... Then enter the same formula into cell "B4," but change "1" to "3" and you will get the third ...

Excel's "trimmean" function calculates the mean of the interior of a data set. You can tailor the function to calculate the interquartile mean. Enter your data set into a single column in Excel.