| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula for adding Columns
Please help ...I'm going mad... How do I enter a formula to add colums
together? Thanks in advance |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding columns by formula | Excel Discussion (Misc queries) | |||
| Adding 8 columns by formula | Excel Discussion (Misc queries) | |||
| Adding Columns, Then deleting old columns | Excel Discussion (Misc queries) | |||
| formula for adding / subtracting two columns . | New Users to Excel | |||
| Adding columns (one with a formula) | New Users to Excel | |||
Linear Mode
