ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hOW DO i SUBTRACT COLUMNS IN EXCEL? (https://www.excelbanter.com/excel-discussion-misc-queries/79636-how-do-i-subtract-columns-excel.html)

Subtract columns

hOW DO i SUBTRACT COLUMNS IN EXCEL?
 
Please help me. I am very new to Excel. I am trying to subtract one column
from the next. I do not know where to put the formula; or even what the
formula would be.? Signed Extremely Frustrated.

gjcase

hOW DO i SUBTRACT COLUMNS IN EXCEL?
 

To subtract Col B from Col C, assuming you have data in hte first 10
rows:

Enter =A1-B1 in col C1. Then copy C1 down thru C10. Excel will adjust
the formula as you copy down. To copy, select C1 and hit Crtl-C , then
highlight c2:c10 and hit Ctrl-V. Alternatively, grab the lower RH
corner of C1 & drag it down thru C10.

Result will be that each cell in Col C is the difference of the
corresponding cells in Cols A & B.

You can try cruising thru the Excel "Help" contents for help on
specific functions.

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=526524



All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com