You probably have a formula like =AVERAGE(A1,A2,A3,......
Instead, use =AVERAGE(A1:A32)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"tee" wrote in message ...
|I am trying to set up a bowling league spreadsheet. The bowling league
| consists of 32 weeks. I need to figure each bowlers individual average for
| 32 weeks which is done by adding up the weekly averages and dividing by the
| numbers of weeks bowled. The program won't let me average more than 30
| fields.
|
| Is there a way around this?
|
| Thanks