Dear community,

I’m currently working on a 37x37 matrix filled with values between 0 and about 250. Most of these values are = 0, but I’m interested in calculating the first and third quartiles + the median of the non-zero values.

My approach was to include the IF-Function in the argument like this: =QUARTILE(IF(C9:AM45>0;C9:AM45); 1) where C9:AM45 is my matrix and 1 stands for the first quartile. Unfortunately it only returns “#value!”.

Has anyone suggestions on how to correctly apply this condition of >0 in the quartile-function?

Many thanks in advance!

Best regards

Marvin