Adding cells

[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
And so on

Thank you

 

[karenp]

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

 

[MartinW]

Hi Kevin,

Put this in E4
=SUM(D$34)

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]

Thanks Martin

Hi Kevin,

Put this in E4
=SUM(D$34)

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

HTH
Martin

 

[Stan Brown]

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$34)

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.