Sum to include (-)/ Text feature

		Microsoft Office Forums > Microsoft Excel > Excel
Sum to include (-)/ Text feature

FAQ

Thread Tools

Display Modes

10-11-2017, 06:38 AM

Haha88

Windows 8

Office 2010 32bit

Advanced Beginner

Join Date: Mar 2015

Posts: 79

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
How to include a tabspace between a text with autocorrect option	kcvinu	Word	6	01-18-2015 11:12 AM
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
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 01:56 PM.