average range function

[Patrick White]

Hi all

I am trying to work out the average value of Column A1:A500.

What I am needing is a formula that will exclude 0 from the calculations to
give a true average.

Probably an easy one, but cannot seem to locate the correct formula.

Cheers

Patrick

 

[Zakir Ulla]

Hi Patrick,

you could use the DAverage formula to only sum values greater than 0

EXAMPLE
|-----------|

values

0

values
0
0
0
0
1
1
1
1
=DAVERAGE(A3:A11,"values",A1:A2)

|---------|

COPY (from values) THE ABOVE AN EXCEL SHEET AND SEE IT WORK!

Regards,
Zakir Ulla



Patrick White said the following on 30/06/2005 1:59 PM:

 

[Patrick White]

Hi Kakir

It is coming up with #DIV/0! error.

Regards

Patrick