Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
How do you go one whole row minus another whole row
|
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dealing with minus numbers in formulas | Excel Discussion (Misc queries) | |||
Equivalent of Minus in Excel. Also Union, Intersect. | Excel Worksheet Functions | |||
converting minus quantities to plus | New Users to Excel | |||
strip minus signs from right to left | Excel Discussion (Misc queries) | |||
minus formel/fortegn | Excel Discussion (Misc queries) |