I need help calculating averages with missing values?

  • Thread starter avg w/ missing #s
  • Start date
A

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!
 
M

Marcelo

try

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

hth
regards from Brazil
Marcelo

"avg w/ missing #s" escreveu:
 
E

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
 
Top