maybe something like

=AVERAGE(ROW(INDIRECT("1998:2005")))

as an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bill" wrote in message
...
How do I get the average of a group of years. Like 1999, 1998, 2000, etc.