SUBTRACT COLUMN A FROM COLUM B =?

[Kate]

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.

 

[Gord Dibben]

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