View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
C01d
 
Posts: n/a
Default 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