Average of a series

  • Thread starter Thread starter vano
  • Start date Start date
V

vano

Hi All,
How do I get an average of a series but I dont want to include cell
that =0

Eg.

00.00
0.00
0.00
775.00
775.00
0.00
0.00
1137.50
1137.50
0.00
0.00
1225.00

I want to find the average of the last 5 cells excluding 0's
I need
1225.00
1137.50
1137.50
775.00
775.00
average


not
1137.50
1137.50
0.00
0.00
1225.00
average


I hope this makes sense.

Thanks in advance,

Va
 
=AVERAGE(IF(A1:A12<>0,A1:A12))

entered with ctrl + shift & enter

or

=SUM(A1:A12)/COUNTIF(A1:A12,"<>0")

--
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 of a series 2
Average IF? 1
Formula Request 4
Problem With An Average IF Formula 3
Customize accounting format 3
How do I retrieve Cost from a grid using text drop down lists? 3
Averages with conditions.... 1
HOW CAN I SET UP IF AMOUNT IN COL A = 0 THEN ADD B COL 4

Back
Top