software

I would like to create a SUM function that goes from A1:A10 (for example) and
does not expand or contract as I add or remove cells within the array.
Currently if I insert a cell, the function will change to A1:A11 which I do
not want. Ideas?

=SUM(INDIRECT(quot;A1:A10quot;))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;cmattmillsquot; gt; wrote in message
...
gt; I would like to create a SUM function that goes from A1:A10 (for example)
and
gt; does not expand or contract as I add or remove cells within the array.
gt; Currently if I insert a cell, the function will change to A1:A11 which I
do
gt; not want. Ideas?
Try something like this:

=SUM(INDIRECT(quot;a1:a10quot;))

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;cmattmillsquot; wrote:

gt; I would like to create a SUM function that goes from A1:A10 (for example) and
gt; does not expand or contract as I add or remove cells within the array.
gt; Currently if I insert a cell, the function will change to A1:A11 which I do
gt; not want. Ideas?

=SUM(INDIRECT(quot;A1:A10quot;))

HTH,
Bernie
MS Excel MVPquot;cmattmillsquot; gt; wrote in message
...
gt;I would like to create a SUM function that goes from A1:A10 (for example) and
gt; does not expand or contract as I add or remove cells within the array.
gt; Currently if I insert a cell, the function will change to A1:A11 which I do
gt; not want. Ideas?
Thank you all for responding so quickly! It works, and now I can get on with
MY work!
quot;Bernie Deitrickquot; wrote:

gt; =SUM(INDIRECT(quot;A1:A10quot;))
gt;
gt; HTH,
gt; Bernie
gt; MS Excel MVP
gt;
gt;
gt; quot;cmattmillsquot; gt; wrote in message
gt; ...
gt; gt;I would like to create a SUM function that goes from A1:A10 (for example) and
gt; gt; does not expand or contract as I add or remove cells within the array.
gt; gt; Currently if I insert a cell, the function will change to A1:A11 which I do
gt; gt; not want. Ideas?
gt;
gt;
gt;