If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Subtract Range Of Numbers using a Formula
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Subtract Range Of Numbers using a Formula

#1
June 21st 06, 03:41 AM posted to microsoft.public.excel.misc
 Josh Davis external usenet poster Posts: n/a
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.

Josh
#2
June 21st 06, 04:05 AM posted to microsoft.public.excel.misc
 Max external usenet poster Posts: n/a
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.
>
>
> Josh

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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 08: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 09:10 PM

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