Average

[Luis Felipe Alcantara]

Hi,

I need the average calculate, but all the zero cell I need delete, to
correct calculate. It exists some formula if excluding the zero cells ?
Sorry, I´m brazilian and my english is very bad !

Best regards,
Luis Alcantara

 

[Peo Sjoblom]

=AVERAGE(IF(A1:A10<>0,A1:A10))

entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)