Adding cells


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
 
Ad

Advertisements

M

MartinW

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
 
K

Kevin

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
 
Ad

Advertisements

S

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$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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top