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
|