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. _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list