Home |
Search |
Today's Posts |
#1
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
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
If formula using 2 or more columns | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Req Formula to place 1 into next columns | Excel Worksheet Functions |