View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tee tee is offline
external usenet poster
 
Posts: 20
Default averaging 32 fields

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