close

Hi, i am making some ammendments to a workbook someone else has created,
with it some of the sheets make extensive use of formulas that resemble
that below, where summ_100 equals a defined range, could someone
explain how and why this works. I'm just a bit unsure as i haven't come
across {} in excel, have an idea that it may be something to do with
arrays.

{=summ_100}The named range is the same dimensions as the range of cells that use
the formula.--
cereldine
------------------------------------------------------------------------
cereldine's Profile: www.excelforum.com/member.php...oamp;userid=32069
View this thread: www.excelforum.com/showthread...hreadid=529572Hi Cereldine,

www.cpearson.com/excel/array.htm

--
Kind regards,

Niek Otten

quot;cereldinequot; gt; wrote in message
...
gt;
gt; Hi, i am making some ammendments to a workbook someone else has created,
gt; with it some of the sheets make extensive use of formulas that resemble
gt; that below, where summ_100 equals a defined range, could someone
gt; explain how and why this works. I'm just a bit unsure as i haven't come
gt; across {} in excel, have an idea that it may be something to do with
gt; arrays.
gt;
gt; {=summ_100}
gt;
gt;
gt; The named range is the same dimensions as the range of cells that use
gt; the formula.
gt;
gt;
gt; --
gt; cereldine
gt; ------------------------------------------------------------------------
gt; cereldine's Profile: www.excelforum.com/member.php...oamp;userid=32069
gt; View this thread: www.excelforum.com/showthread...hreadid=529572
gt;

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

    software

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