Calculation with non zero array values

[PleaseExcelHelp]

Hi there,
Does anyone know how to perform an array calculation with only non zero values?

Specifically, I wish to calculate the first quartile of an array of values that contains zeros (but remove the zeros during the calculation). I've tried a formula like this:

=QUARTILE.INC(IF(C13:V13>0, C13:V13),1)

I'm using Excel 2010. Your help is most appreciated.

Cheers!

[daddylonglegs]

What result did you get with that formula? It should work but you need to confirm with CTRL+SHIFT+ENTER

Put formula in cell then press F2 key to select and hold down CTRL and SHIFT keys and press ENTER so that curly braces like { and } appear around the formula

[PleaseExcelHelp]

Hi daddylonglegs,
Thanks for the tip. Worked like a charm! I had read posts that stated to perform CTRL+SHIFT+ENTER, to properly perform the array function, but earlier today I would only return with the function surrounded by { }. The difference now is the F2 key (I think, now the return is numeric & correct).

Thanks so much!