Formula for adding Columns
 

Please help ...I'm going mad... How do I enter a formula to add colums
together?

Thanks in advance

Formula for adding Columns
 

Your problem is not clear... pl. provide more information with sample data.

If you want to add A1, B1, C1 in D1 then use
=A1+B1+C1 in D1

"Gary" wrote:

Please help ...I'm going mad... How do I enter a formula to add colums
together?

Thanks in advance

Formula for adding Columns
 

Do you want to SUM them then add them or just add rows across?, can you
explain a little more?

Gary;230898 Wrote:
Please help ...I'm going mad... How do I enter a formula to add colums
together?

Thanks in advance


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64518

Formula for adding Columns
 

Sorry... I want to take C, subtract D and E to get F (C-D-E=F) . In other
words, I want to take each line, start with sales (C) subtract fees (D) and
Tax (E) to get a net Sales figure. I know how to do it one cell at a time,
but I know there's a way to set it up once so that it will happen
automatically on each line... But I can't recall how to do it..nor can I
find it in any "Help" resource. So I really appreciate your interest...

"Sheeloo" wrote:

Your problem is not clear... pl. provide more information with sample data.

If you want to add A1, B1, C1 in D1 then use
=A1+B1+C1 in D1

"Gary" wrote:

Please help ...I'm going mad... How do I enter a formula to add colums
together?

Thanks in advance

Formula for adding Columns
 

Sorry... I want to take C, subtract D and E to get F (C-D-E=F) . In other
words, I want to take each line, start with sales (C) subtract fees (D) and
Tax (E) to get a net Sales figure. I know how to do it one cell at a time,
but I know there's a way to set it up once so that it will happen
automatically on each line... But I can't recall how to do it..nor can I
find it in any "Help" resource. So I really appreciate your interest...



"Simon Lloyd" wrote:


Do you want to SUM them then add them or just add rows across?, can you
explain a little more?

Gary;230898 Wrote:
Please help ...I'm going mad... How do I enter a formula to add colums
together?

Thanks in advance


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64518

Formula for adding Columns
 

Gary

Set up the top row as you have indicated you know how. Select the cell in
column F that has your formula and move the curser to the lower left corner
and watch for it to change from a large white plus sign to a smaller back
plus sign. Once it has you have found the "Fill Handle" click and drag this
to the bottom of your data. Depanding on your layout you may be able to
double click on the fill handle and it will automatically fill to the bottom
of your data. One of these ways will hopefully help.

Mike Rogers

"" wrote:

Sorry... I want to take C, subtract D and E to get F (C-D-E=F) . In other
words, I want to take each line, start with sales (C) subtract fees (D) and
Tax (E) to get a net Sales figure. I know how to do it one cell at a time,
but I know there's a way to set it up once so that it will happen
automatically on each line... But I can't recall how to do it..nor can I
find it in any "Help" resource. So I really appreciate your interest...



"Simon Lloyd" wrote:


Do you want to SUM them then add them or just add rows across?, can you
explain a little more?

Gary;230898 Wrote:
Please help ...I'm going mad... How do I enter a formula to add colums
together?

Thanks in advance


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64518

Formula for adding Columns
 

Ok, put this in F2 (assuming you have headers)* =C2-D2-E2 *now with F2
selected press Ctrl+Shift+End then click EDITFILLFILL DOWN, now your
done!

Gary;230962 Wrote:
Sorry... I want to take C, subtract D and E to get F (C-D-E=F) . In
other
words, I want to take each line, start with sales (C) subtract fees (D)
and
Tax (E) to get a net Sales figure. I know how to do it one cell at a
time,
but I know there's a way to set it up once so that it will happen
automatically on each line... But I can't recall how to do it..nor can
I
find it in any "Help" resource. So I really appreciate your interest...

"Sheeloo" wrote:

Your problem is not clear... pl. provide more information with sample
data.

If you want to add A1, B1, C1 in D1 then use
=A1+B1+C1 in D1

"Gary" wrote:

Please help ...I'm going mad... How do I enter a formula to add
colums
together?

Thanks in advance


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64518

Formula for adding Columns
 

Hi,

If I understand you want a single formula to give the result of all of the
rows: suppose your data runs from row 2 to 100 then

=SUMPRODUCT(C2:C100-(D2:D100+E2:E100))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Gary" wrote:

Sorry... I want to take C, subtract D and E to get F (C-D-E=F) . In other
words, I want to take each line, start with sales (C) subtract fees (D) and
Tax (E) to get a net Sales figure. I know how to do it one cell at a time,
but I know there's a way to set it up once so that it will happen
automatically on each line... But I can't recall how to do it..nor can I
find it in any "Help" resource. So I really appreciate your interest...



"Simon Lloyd" wrote:


Do you want to SUM them then add them or just add rows across?, can you
explain a little more?

Gary;230898 Wrote:
Please help ...I'm going mad... How do I enter a formula to add colums
together?

Thanks in advance


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64518