Average cells > 5

[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

 

[Jason Morin]

One way:

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

HTH
Jason
Atlanta, GA

 

[Peo Sjoblom]

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

entered with ctrl + shift & enter

or

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