Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-11-2017, 06:38 AM
Haha88 Haha88 is offline Sum to include (-)/ Text feature Windows 8 Sum to include (-)/ Text feature Office 2010 32bit
Advanced Beginner
Sum to include (-)/ Text feature
 
Join Date: Mar 2015
Posts: 75
Haha88 is on a distinguished road
Default Sum to include (-)/ Text feature

Hi,

Can someone help me with the formula for sum/sumtotal to include "-" or text please.

for example:
100 - =sum(d4-e4)
150
300 -


500 -
- 135
- 26.3
- 44.8
- 597.31
- 47.7
- 42.5

Thank you.
Reply With Quote
  #2  
Old 10-11-2017, 06:43 AM
gebobs gebobs is offline Sum to include (-)/ Text feature Windows 7 64bit Sum to include (-)/ Text feature Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Erm...what?
Reply With Quote
  #3  
Old 10-11-2017, 06:58 AM
Haha88 Haha88 is offline Sum to include (-)/ Text feature Windows 8 Sum to include (-)/ Text feature Office 2010 32bit
Advanced Beginner
Sum to include (-)/ Text feature
 
Join Date: Mar 2015
Posts: 75
Haha88 is on a distinguished road
Default

Sorry, I attached a worksheet for a better view.
Thanks,
Attached Files
File Type: xlsx Book2.xlsx (8.8 KB, 8 views)
Reply With Quote
  #4  
Old 10-11-2017, 07:49 AM
xor xor is offline Sum to include (-)/ Text feature Windows 10 Sum to include (-)/ Text feature Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Do you mean C4-D4, C5-D5 etc.?

If yes then try in F4:

=N(C4)-N(D4) and copy down.
Reply With Quote
  #5  
Old 10-11-2017, 02:55 PM
Haha88 Haha88 is offline Sum to include (-)/ Text feature Windows 8 Sum to include (-)/ Text feature Office 2010 32bit
Advanced Beginner
Sum to include (-)/ Text feature
 
Join Date: Mar 2015
Posts: 75
Haha88 is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Do you mean C4-D4, C5-D5 etc.?

If yes then try in F4:

=N(C4)-N(D4) and copy down.

Brilliant! Many thanks.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum to include (-)/ Text feature Is it possible to include an entry in a TOC without the text being in the body? Makandriaco Word 7 01-26-2016 03:54 PM
Sum to include (-)/ Text feature How to include a tabspace between a text with autocorrect option kcvinu Word 6 01-18-2015 11:12 AM
Sum to include (-)/ Text feature Include block of text with merge fields. Mulith Mail Merge 2 10-30-2014 03:59 AM
include heading text in header eNGiNe Word 2 03-06-2013 12:24 AM
Sum to include (-)/ Text feature Word 2003 - IncludeText Does Not Include Bookmark Text if in a Form Text Control skarden Word 1 12-12-2011 10:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft