Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 21st 06, 03:41 AM posted to microsoft.public.excel.misc
Josh Davis
 
Posts: n/a
Default Subtract Range Of Numbers using a Formula

Hello,

I was wanting to take a standard currency form cell containing the following
number: "$180.00" in cell "F4" and be able to subtract that from the nubers
formatted in the currency form in cells "F5:F10" so that the difference in
these numbers is displayed in cell "F12". If you do not understand this let
me put this in a mathmatical sense. I want to take the $180.00, subtract
32.09-16.27-16.27-19.48-15.35-44.69. those ammount are cells "F5:F10" I would
like the difference of those totals displayed in cell "F12" as previously
stated. So can anyone help me? your help would be greatly appreciated.

Thanks In Advance,

Josh

  #2   Report Post  
Old June 21st 06, 04:05 AM posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default Subtract Range Of Numbers using a Formula

Perhaps ... in F12: =F4-SUM(F5:F10)
would do it here ?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Josh Davis" wrote:
Hello,

I was wanting to take a standard currency form cell containing the following
number: "$180.00" in cell "F4" and be able to subtract that from the nubers
formatted in the currency form in cells "F5:F10" so that the difference in
these numbers is displayed in cell "F12". If you do not understand this let
me put this in a mathmatical sense. I want to take the $180.00, subtract
32.09-16.27-16.27-19.48-15.35-44.69. those ammount are cells "F5:F10" I would
like the difference of those totals displayed in cell "F12" as previously
stated. So can anyone help me? your help would be greatly appreciated.

Thanks In Advance,

Josh



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
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 09:02 PM
Count comma separated numbers, numbers in a range with dash, not t Mahendra Excel Discussion (Misc queries) 0 August 8th 05 05:56 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM
What formula is used for subtracting a range of different cells f. tim Excel Worksheet Functions 2 January 12th 05 10:10 PM


All times are GMT +1. The time now is 09:48 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017