Average

  • Thread starter Thread starter Luis Felipe Alcantara
  • Start date Start date
L

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
 
=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

average with exception of some cells? 5
=AVERAGE (see underlying values?) 7
Averaging non consecutive cells excluding zero's 4
Excel 2007 average formula 3
Average Function 4
averaging numbers 5
AVERAGE formula with a twist 5
Subtotal Average excluding zero 9

Back
Top