Average of column with changing numbers of records

[Bikertyke]

I'm trying to find the average of a column of numbers by suming and dividing
by the number of records i.e. =sum(a1:a100)/100. Is there anyway I can use
the number of records to replace the 'divided by number' i.e.
=sum(a1:a10)/number of records or cells with a values greater than 0 when the
are only for instance 50 recored in the column?
I want to get away from having to change the 'devided by' number so when I
add records the 'devided by' value increases.

Cheers

 

[Bob I]

Perhaps use DAVERAGE instead?

 

[Pete_UK]

Try it this way:

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

Hope this helps.

Pete

 

[Max]

You could use this, in B1, array-entered*:
=AVERAGE(IF(A1:A100>0,A1:A100))

*press CTRL+SHIFT+ENTER to confirm the formula
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 15,500, Files: 352, Subscribers: 53
xdemechanik

 

[scp3030]

what about using a countif function,

(ie countif > 0)

 

[Bikertyke]

Thanks for the ideas... you're stars.