Average Formula

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

How can I write the average formula so it does not count the cells with zeros
in it...
A1= 12
A2= 0
A3 = 12
A4 = 0
A5= 12
A6 =0
if I write the formula as =average(a1:a6) the value is 6, but I want it to
read 12.
 
{=AVERAGE(IF(A1:A6<>0,A1:A6))}
*** This is an array formula, and is to be confirmed with CTRL+SHIFT+ENTER
rather than with simply ENTER.
The curly brackets {} are not to be typed manually, those are entered by the
“Excelâ€, when the formula is entered as an Array formula. ***
Micky
 
Back
Top