In E4 I am trying to add D3, D4
In E5 I am trying to add D3, D4, D5
In E6 I am trying to add D3, D4, D5, D6
And so on

Thank you

Sounds like you are doing formulas. In E4 type =d3:d4, in E4 type =d3:d5

"Kevin" wrote:

In E4 I am trying to add D3, D4
In E5 I am trying to add D3, D4, D5
In E6 I am trying to add D3, D4, D5, D6
And so on

Thank you

Hi Kevin,

Put this in E4
=SUM(D$3:D4)

Click on the fill handle and drag it down
as far as you need, the formula will update
as you drag it.

HTH
Martin


"Kevin" wrote in message
...
In E4 I am trying to add D3, D4
In E5 I am trying to add D3, D4, D5
In E6 I am trying to add D3, D4, D5, D6
And so on

Thank you

Thanks Martin

"MartinW" wrote:

Hi Kevin,

Put this in E4
=SUM(D$3:D4)

Click on the fill handle and drag it down
as far as you need, the formula will update
as you drag it.

HTH
Martin


"Kevin" wrote in message
...
In E4 I am trying to add D3, D4
In E5 I am trying to add D3, D4, D5
In E6 I am trying to add D3, D4, D5, D6
And so on

Thank you

Mon, 7 Jan 2008 19:06:01 -0800 from Kevin
:
In E4 I am trying to add D3, D4
In E5 I am trying to add D3, D4, D5
In E6 I am trying to add D3, D4, D5, D6

In E4 put this formula: =sum(D$3:D4)

Then drag the fill handle to E5, E6, and as far as you need to go.

That $ sign in D$3 says that as you copy or move the formula, the
"3" part won't change even though the rest does.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/