Average cells > 5

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

Daniel Bonallack

Could someone please give me a formula to average all
values in column A only if the cells are not blank, and
are greater than 5 (so I guess it's enough to say only if
the value is greater than 5).

Thanks
Daniel
 
=AVERAGE(IF(A1:A10>5,A1:A10))

entered with ctrl + shift & enter

or

=SUMIF(A1:A10,">5")/COUNTIF(A1:A10,">5")
 
Back
Top