In C1 enter =B1-A1

Copy that down column C as far as you wish. Wil. subtract single cell from
single cell

=SUM(B:B)-SUM(A:A) Will Subtract entire column from entire column.

Without more detail I can't give much more.


Gord Dibben MS Excel MVP

On Mon, 28 Apr 2008 20:07:19 -0700, uindt
wrote:

how to subtract one column to another