I need help calculating averages with missing values?
 

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!

I need help calculating averages with missing values?
 

try

=average(if(a2:a70,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!

I need help calculating averages with missing values?
 

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:a70,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!