Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default subtract column right from column left in excel?

How do I do entire columns with the same function, like subtraction?
I have excel 2003.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,104
Default subtract column right from column left in excel?

Question is unclear, please expand on what you want to do
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Muffin" wrote in message
...
How do I do entire columns with the same function, like subtraction?
I have excel 2003.



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,276
Default subtract column right from column left in excel?

Hi,
if what you mean is each row

=B1-A1

if you mean the whole column

=sum(B1:B60000)-sum(A1:A60000)


"Muffin" wrote:

How do I do entire columns with the same function, like subtraction?
I have excel 2003.

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
Tell a column to always subtract --Excel 2003 BonsH Excel Discussion (Misc queries) 4 June 11th 09 04:13 PM
sum of every forth column to left excel Robin Excel Discussion (Misc queries) 2 November 2nd 08 10:00 PM
Right column doesn't change when sorting left column. nohope Excel Discussion (Misc queries) 2 July 19th 05 03:27 PM
strange column to the left of my row numbers column Relztrah Excel Discussion (Misc queries) 1 May 23rd 05 06:37 PM
How do I subtract 20% from one column in Excel and place totals i. Full Effect Landscaping Excel Discussion (Misc queries) 2 February 2nd 05 01:42 AM


All times are GMT +1. The time now is 09: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"