Average of column with changing numbers of records
 

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

Average of column with changing numbers of records
 

Perhaps use DAVERAGE instead?

Bikertyke wrote:

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

Average of column with changing numbers of records
 

Try it this way:

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

Hope this helps.

Pete

"Bikertyke" wrote in message
...
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

Average of column with changing numbers of records
 

You could use this, in B1, array-entered*:
=AVERAGE(IF(A1:A1000,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
---
"Bikertyke" wrote:
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

Average of column with changing numbers of records
 

what about using a countif function,

(ie countif 0)

"Bikertyke" wrote:

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

Average of column with changing numbers of records
 

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

"Bikertyke" wrote:

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