|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 24th, 2006, 08:21 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
formula for adding / subtracting two columns .
Can't find formula to add or subtract two or three entire columns in a spread
sheet Thank you 
|
|
#2
May 24th, 2006, 09:54 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula for adding / subtracting two columns .
Let's say we have numbers in two columns, column A and column B from rows 1
thru 100. In C1, enter: =A1+B1 and copy down thru C100 Column C will be the sum of columns A & B. To get the grand sum of columns A & B in a single cell, enter in an un-used cell: =SUM(A1:B100) -- Gary''s Student "jm" wrote: Can't find formula to add or subtract two or three entire columns in a spread sheet Thank you
|
|
#3
May 24th, 2006, 10:50 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
formula for adding / subtracting two columns .
Hi
Try something like: =SUM(A:A)-SUM(B:B)-SUM(C:C) Andy. "jm" wrote in message ... Can't find formula to add or subtract two or three entire columns in a spread sheet Thank you
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| adding row to forumla | carrera | General Discussion | 9 | August 23rd, 2005 10:24 PM |
| Adding columns (one with a formula) | PaulStroik | New Users | 7 | June 27th, 2005 10:32 PM |
| Formula checking multiple worksheets | sonic-the-mouse | Worksheet Functions | 11 | June 6th, 2005 06:37 PM |
| I need to Sum multiple columns by referencing one formula. | GaryZ | Worksheet Functions | 2 | July 3rd, 2004 12:45 PM |
| Using arrays in columns and rows in same formula | David | Worksheet Functions | 1 | April 21st, 2004 12:22 AM |
Linear Mode
