Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Thanks to those who replied. USing the array formula did give me some success. Here is the equation that I am using. It draws data from a sheet called 311. {=AVERAGE(ABS('311'!N2:'311'!N45-MEDIAN('311'!N2:'311'!N45)))} However, this formula only works when I manually enter in the 45 (only N2:N45 contains data). In other words, if I had '311'!N2:'311'!N100 instead of '311'!N2:'311'!N45, the formula wouldn't work. But then if I add some new data to the end of the list, I would want '311'!N2:'311'!N46 instead of '311'!N2:'311'!N45. How can I make this number automatically change. I know that INDIRECT will do the trick (since I have another cell that counts the number of rows of data in the list), but I'm not sure about the syntax of INDIRECT when referencing cells in other sheets. If anyone can help, please reply -- Spreadsheet ------------------------------------------------------------------------ Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730 View this thread: http://www.excelforum.com/showthread...hreadid=547659 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Math problem | Excel Worksheet Functions | |||
I have a math problem in Excel. | Excel Discussion (Misc queries) | |||
math symbols functions | New Users to Excel | |||
Cell Reference Math | Excel Worksheet Functions | |||
How do I do math on a cell name in formula? | Excel Worksheet Functions |