Help with average formula

  • Thread starter Thread starter Juha
  • Start date Start date
J

Juha

Hi,

I'm trying to calculate average of figures as follows:


1.1.2003 10
2.1.2003 20
3.1.2003 15
4.1.2003
5.1.2003 5

So the question is that if there is one row that has no numbers in it
how do I exclude it from the average... meaning that average would b
counted like this (10+20+15+5)/4 and not (10+20+15+5)/5.

Thanks
//juh
 
Back
Top