tee wrote...
HP6
=AVERAGE(H6,N6,U6,AB6,AI6,AP6,AW6,BD6,BK6,BR6,BY6 ,CF6,CM6,CT6,
DA6,DH6,DO6,DV6,EC6,EJ6,EQ6,EX6,FE6,FL6,FS6,FZ6,G G6,GN6,GU6,HB6,HI6)

The program will not let me include HB6 and HI6. I have to stop at GU6
because I can only average 30 fields.
....

So make it one multiple area range.

=AVERAGE((H6,N6,U6,AB6,AI6,AP6,AW6,BD6,BK6,BR6,BY6 ,CF6,CM6,CT6,
DA6,DH6,DO6,DV6,EC6,EJ6,EQ6,EX6,FE6,FL6,FS6,FZ6,GG 6,GN6,GU6,HB6,HI6))