mercredi 9 mai 2018

Find quartile of range based on value in other column

I have the following data in excel starting in cell A1. I want to find the 25th percentile (quartile 1) of the "Time" data based on the Month. For example, what is the 1 quartile of the time data in Apr-17? I wrote this formula, but it did not work.

What formula can one write to answer the question posed above?

=IF(Month = Apr-17, QUARTILE(B2:B9,1),"")

enter image description here

Aucun commentaire:

Enregistrer un commentaire