Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > Subtracting
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JS JS is offline
external usenet poster
  
Posts: 44
Default Subtracting
How can I subtract a range of numbers from another number?
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
  
Posts: 3,101
Default Subtracting
=A1-SUM(A2:A9)

Try that

"JS" wrote:

How can I subtract a range of numbers from another number?
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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
Subtracting JS Excel Worksheet Functions 2 March 9th 07 09:49 PM
Subtracting [email protected] Excel Discussion (Misc queries) 3 February 18th 07 05:07 AM
Subtracting petrino Charts and Charting in Excel 2 January 9th 07 08:56 AM
Subtracting Paul M Excel Discussion (Misc queries) 0 February 15th 06 05:49 PM
Subtracting One Sum From Another R. U. Sirius New Users to Excel 3 September 27th 05 06:47 PM


All times are GMT +1. The time now is 01:30 AM.

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

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement