#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Erm...what?
|
#3
|
|||
|
|||
Sorry, I attached a worksheet for a better view.
Thanks, |
#4
|
|||
|
|||
Do you mean C4-D4, C5-D5 etc.?
If yes then try in F4: =N(C4)-N(D4) and copy down. |
#5
|
|||
|
|||
Quote:
Brilliant! Many thanks. |
Thread Tools | |
Display Modes | |
|
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 |