ExcelBanter - How do you go one whole row minus another whole row

Your question is a little vague. If what you're trying to do is to
difference between the totals of the two rows, you will first have to
find the sum of each row using a SUM formula.

However, if you are trying to find the difference between each cell in
the 2 rows, you'll have to enter this formula in a new row (e.g. in
cell A3) :
=A1-A2

With the cell selected, you can then drag the handle (the black box at
the bottom-right corner of the cell) across the row to populate it with
the formula.

--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=550700