| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Field in Pivot Table Based on Two Counted Fields | Excel Discussion (Misc queries) | |||
| Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
| Changing the range of several averaging functions | Excel Discussion (Misc queries) | |||
| Number of dropdown fields in Excel is limited. I need more. How? | Excel Discussion (Misc queries) | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Threaded Mode
