Formula for adding Columns

[Gary]

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

Thanks in advance

 

[Sheeloo]

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

 

[Simon Lloyd]

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

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

Thanks in advanc

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Gary]

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

 

[Gary]

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

 

[Mike Rogers]

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

 

[Simon Lloyd]

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

Sorry... I want to take C, subtract D and E to get F (C-D-E=F) . I
othe
words, I want to take each line, start with sales (C) subtract fees (D
an
Tax (E) to get a net Sales figure. I know how to do it one cell at
time
but I know there's a way to set it up once so that it will happe
automatically on each line... But I can't recall how to do it..nor ca

find it in any "Help" resource. So I really appreciate your interest..

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com

 

[Shane Devenshire]

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-(D2100+E2:E100))