How do you go one whole row minus another whole row

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

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

With the cell selected, you can then drag the handle (the black box a
the bottom-right corner of the cell) across the row to populate it wit
the formula
 
Back
Top