Calculate average that ignores zeros

  • Thread starter Thread starter Cindy
  • Start date Start date
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
 
Enter the formula you are using, and then, instead of hitting <Enter>, hold
down <Ctrl><Shift> and then hit enter.
 
When creating/editing array formulas instead of ENTER use
Control+Shift+ENTER. It will wind up looking like {formula}
 
Back
Top