View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default averaging 32 fields

It's best if you stay in the original thread so others can see what has
previously been suggested.

Anyway, do you have a typo, or is it intentional that you start off with 6
columns, and then switch to every 7 columns?

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------



"tee" wrote in message
...
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,H B6,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