| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
SUBTRACT COLUMN A FROM COLUM B =?
I want to subtract Column A from Column B and Column C be the result. I've
been doing each row calculation and I know there is an easier way. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
SUBTRACT COLUMN A FROM COLUM B =?
Not sure what you need.
In C1 enter =B1-A1 and drag/copy down to bottom of A and B or just double-click on the fill handle (black lump at lower right corner) of C1 Or maybe in C1 =SUM(B:B)-SUM(A:A) which subtracts total of A from total of B You decide which you need. Gord Dibben MS Excel MVP On Tue, 1 Aug 2006 12:09:01 -0700, Kate wrote: I want to subtract Column A from Column B and Column C be the result. I've been doing each row calculation and I know there is an easier way. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I combine column A into Colum B? | Excel Discussion (Misc queries) | |||
| subtract column E to column D in every row | Excel Discussion (Misc queries) | |||
| find text in column h and total the corresponding numbers if colum | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Linear Mode
