| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging cells in separate workbooks to make year-to-date average
I need the average from 4 different workbooks (which are averaged from 3
other workbooks!) to make a year-to-date running total. I can't get this total without values entered in all 4 workbooks in which case we won't have until all data for the year has been entered but we need to see the running total now. This is the formula I'm using =AVERAGE('1st Quarter Jan-Mar'!G40,'2nd Quarter Apr-Jun'!G40,'3rd Quarter Jul-Sep'!G40,'4th Quarter Oct-Dec'!G40) it gives me #DIV/O! unless all 4 workbooks have values. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average If - averaging cells based on value of another cell | Excel Worksheet Functions | |||
| averaging separate cells in excel excluding 0 values | Excel Discussion (Misc queries) | |||
| Elapsed time when separate cells contain time and separate date | New Users to Excel | |||
| linking 12 monthly workbooks to one year to date workbook | Excel Worksheet Functions | |||
| Due Date with year using IF for several cells | Excel Worksheet Functions | |||
Threaded Mode
