close

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: www.excelforum.com/member.php...oamp;userid=26462
View this thread: www.excelforum.com/showthread...hreadid=506816

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄