Hi,

This is an array formula.

From Excel Help:

A formula that performs multiple calculations on one or more sets of values,
and then returns either a single result or multiple results. Array formulas
are enclosed between braces { } and are entered by pressing
CTRL+SHIFT+ENTER.

Take a look at he
http://www.cpearson.com/excel/array.htm
http://www.emailoffice.com/excel/arrays-bobumlas.html

kk


"rmellison" wrote in message
...
That also works, thanks. But I'm curious, what does Ctrl+Shift+Enter do to
the formula? Does that just have the effect of ignoring zeroes or does it
serve some other purpose? It may be useful again....


"kk" wrote:

Hi

Hope this help...

=Average(If(A1:Z1=0,"",A1:Z1))

Confirmed the formula by pressing Ctrl + Shift + Enter


"rmellison" wrote in message
...
I have a large array of data which has intermittent zero values in it
where
the data has not been acquired. I want to create a generic formula which I
can copy down one column that gives me the median average of the data in
one
row, but does not include zero values. I have been able to do this for the
mean average by using the formula =(SUM(A1:Z1))/(COUNTIF(A1:Z1, "<0")),
(if
there is an easier way, let me know) but I cannot see a way of doing
something similar for the median. BTW, i have tried deselecting 'zero
values'
in the options tab but it merely hides the zeroes, and still uses them in
the
calculations.

Any thoughts gladly appreciated.