Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Subtract columns
 
Posts: n/a
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
gjcase
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
hOW DO i SUBTRACT COLUMNS IN EXCEL? Toppers Excel Discussion (Misc queries) 0 March 26th 06 11:50 PM
Can I use Excel to match text data from 2 separate columns ? Dan Excel Worksheet Functions 1 September 29th 05 03:51 AM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 02:04 AM
Add more lines and more columns in Excel Marc Charbonneau Excel Worksheet Functions 3 January 20th 05 03:44 AM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM


All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"