# Re: Obtaining the average or mean from an entire column

• From: Jean Bréfort <jean brefort normalesup org>
• To: Michael Johnson <colloquial collision gmail com>
• Cc: gnumeric-list gnome org
• Subject: Re: Obtaining the average or mean from an entire column
• Date: Sun, 14 May 2006 13:07:51 +0200

```Le dimanche 14 mai 2006 à 03:36 -0700, Michael Johnson a écrit :
```
```Hello, I'm a new Gnumeric user and am having trouble with functions.

I would like to get an average of an entire column into a seperate
cell. The problem is that over the next few months (or years) this
column will be regularly updated. So I was thinking I could use a
function to count the entire number of cells in this column and then
using that number specify the location of the last cell.

I could then inform Gnumeric to start at a particular cell and then go
from that cell to the final specified cell and use the data to get an
average of the entire column.

Is there any function that will have Gnumeric look at a column and
return the number of cells in the range? And could I then use that
number to dynamically specify the final column to use in the average?
```
```
You can count cells containing numbers with:
=cell(A:A)
(this is for the A column).
But you do not need that to calculate the average:
=average(A:A)
calculates the everage of all cells in the A column which contain
numbers.

```