LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spreadsheet
 
Posts: n/a
Default *Tough Math Question*


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Math problem Djbaker70 Excel Worksheet Functions 1 March 24th 06 06:08 PM
I have a math problem in Excel. Djbaker70 Excel Discussion (Misc queries) 2 March 23rd 06 11:55 PM
math symbols functions Fontless New Users to Excel 1 March 6th 05 08:36 PM
Cell Reference Math Ralph Howarth Excel Worksheet Functions 0 January 26th 05 06:27 PM
How do I do math on a cell name in formula? Mark Mulik Excel Worksheet Functions 3 November 23rd 04 03:43 PM


All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"