I need help calculating averages with missing values?

[avg w/ missing #s]

I have tried what they tell me on the help page
=AVERAGE (IF(A2:A7,.0. A2:A7, ""))

but it does not work- I really need to figure it out-- any help would be
really appreciated!

[Marcelo]

try

=average(if(a2:a7>0,a2:a7,""))

hth
regards from Brazil
Marcelo

"avg w/ missing #s" escreveu:

> I have tried what they tell me on the help page
> =AVERAGE (IF(A2:A7,.0. A2:A7, ""))
>
> but it does not work- I really need to figure it out-- any help would be
> really appreciated!

[Elkar]

Note that this is an Array Formula. It should be entered with
CTRL-SHIFT-ENTER instead of just Enter. If done properly, the formula should
appear in the formula bar with { } surrounding it.

HTH,
Elkar


"Marcelo" wrote:

> try
>
> =average(if(a2:a7>0,a2:a7,""))
>
> hth
> regards from Brazil
> Marcelo
>
> "avg w/ missing #s" escreveu:
>
> > I have tried what they tell me on the help page
> > =AVERAGE (IF(A2:A7,.0. A2:A7, ""))
> >
> > but it does not work- I really need to figure it out-- any help would be
> > really appreciated!