Calculate average that ignores zeros

C

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
 
L

Laura Cook

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

Don Guillett

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