In article ,
says...
HP6=AVERAGE(H6,N6,U6,AB6,AI6,AP6,AW6,BD6,BK6,BR6,B Y6,CF6,CM6,CT6,DA6,DH6,DO6,DV6,EC6,EJ6,EQ6,EX6,FE6 ,FL6,FS6,FZ6,GG6,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.

I recently asked this question and Bif told me to post the formula.

Thanks

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

AVERAGE accepts only 30 arguments but each argument can consist of multiple
discontiguous ranges. That's what the 2nd set of parenthesis does. It
tells AVERAGE there is only one argument and it contains so many
discontiguous ranges.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions