Hi

I have a sheet containing a full years data: columns conatining parameters
and rows containing recordsets per day of the year.
I have a button that hides rows per a month selection in a combo box. I
want to calculate averages for all the columns for a specific month. This
must be displayed in the last row - this actually being the empty row below
the 31 Dec 2005. This row is vissible at the bottom of each displayed month.

When I just put a function in there it only calcualtes the average for a
fixed number of rows. How do I change it that it calculates the average
dynamicaly as per the month selected.

This is to enable a monthly report to be printed out that shows average at
the bottom of each column.

thanks
Francois