Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
operations on arrays
to make this easier, i'll start off with an example. i have two named ranges, and i want to find the sum of their differences. to do this, i use an array formula: {=sum(a-b)}, which gives a single number. now, how do i do calculations on that result without having to do a calculation on that particular cell? in other words, i want to write a long formula in a single cell that operates on that array result. thanks. -- dreamz ------------------------------------------------------------------------ dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462 View this thread: http://www.excelforum.com/showthread...hreadid=506816 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using CORREL with arrays containing null values | Excel Discussion (Misc queries) | |||
vba adding arrays | Excel Discussion (Misc queries) | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
Comparing Arrays | Excel Discussion (Misc queries) | |||
Document, if supported, operations with text arrays. i.e: count i. | Excel Worksheet Functions |