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.