Calculate average that ignores zeros

[Cindy]

I'm trying to calculate an average for a column of numbers
that includes zeros. I found this formula =AVERAGE(IF
(A2:A7<>0, A2:A7,"")) but I get a #VALUE error message.
The help file states the formula must be entered as an
array formula. What's an array formula and what am I doing
wrong? thx - cindy

 

[Laura Cook]

Enter the formula you are using, and then, instead of hitting <Enter>, hold
down <Ctrl><Shift> and then hit enter.

 

[Don Guillett]

When creating/editing array formulas instead of ENTER use
Control+Shift+ENTER. It will wind up looking like {formula}