| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rolling Average for Prediction
Hello again, Well I've just figured out why the values display as 0... and read about appropriate error trapping etc. However, I've just realised that this is not an option as the result im linking to from another sheet is actually 0! - as its the result of an addition of null cells. The spreadsheet is too large to introduce error trapping to all the Sum() functions, does anyone know of another way around this problem? Untidy but effective is fine lol. Cheers -- DangerMouse ------------------------------------------------------------------------ DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755 View this thread: http://www.excelforum.com/showthread...hreadid=553165 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rolling average | Excel Worksheet Functions | |||
| rolling 12 month average | Excel Worksheet Functions | |||
| Rolling Average | Excel Worksheet Functions | |||
| Formula for calculating a rolling 12 month average in excel? | Excel Discussion (Misc queries) | |||
| Rolling Average | Excel Discussion (Misc queries) | |||
Threaded Mode
