locked
Quartile Function in MS Excel RRS feed

  • Question

  • I have a column with numbers (which include zeros), blanks, and text, where all column cells have been formatted for "currency".  How do I use the Quartile function on this data so that it gives me MIN, First Quartile, Median, Third Quartile, and MAX values based only on numbers that are greater than zero in that column?  In other words, how do I use the Quartile Function in MS Excel for a range of values while excluding those cells within this range that are either blanks or contain either zeros or text entries? 

    Wednesday, October 8, 2008 9:02 PM