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.

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.