Adding cells

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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
 
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
 
Thanks Martin

MartinW said:
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
Click to expand...
 
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
Click to expand...

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.
 
Back
Top