| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average formula across future worksheets
I have an average formula =average(start:end!b37) that finds the average
across all the worksheets between the sheets named Start and End. However, I use a macro which creates the End page when a user enters data. The formula drops the "End" reference before the sheet is created. How can I lock the formula so that it will always include "end"? (I am happy to get an error message until the End page is created) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average formula multiple worksheets | Excel Discussion (Misc queries) | |||
| Still trying to average 4 worksheets and having formula problems | Excel Discussion (Misc queries) | |||
| Basic Future Value Formula & Interest Rate Formula | Excel Discussion (Misc queries) | |||
| Determine Future Value to Meet Average | Excel Worksheet Functions | |||
| =Average(if( formula using different worksheets | Excel Worksheet Functions | |||
Threaded Mode
