averaging without zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

To All:
I need help with following what is the formula for obtaining of three
numbers when there are zeros in the column

31.26
31.90
31.83
0
0
0
How do I average the above without zero making this six lnumber ro
average .
Or how can I use only the two lower numbers.

ThanKs

Zeta
 
Zeta,

=AVERAGE(IF(A1:A6>0,A1:A6))

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Bob Phillips said:
Zeta,

=AVERAGE(IF(A1:A6>0,A1:A6))

which is an array formula, so commit with Ctrl-Shift-Enter
Click to expand...

Thanks that did the trick, If i may ask you one more question?

Is there a formula that will I can use with formula to select only the two
smallest numbers.

31.26
31.90
31.83
0
0
0
31.885- =AVERAGE(IF(A1:A6>0,A1:A6, average(small,{1,2))?

Thanks,

Zeta
 
Zeta,

=AVERAGE(SMALL(IF(A1:A6>0,A1:A6),{1,2}))

again array entered

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top