|
|
|
|
#1
05-06-2019, 01:04 PM
|
|||
|
|||
Extract numbers from parentheses and add them up
I checked it out with SUM and it gives the same result (40). That seems odd. It is also odd that it works in Sheets. SUMPRODUCT seems more complex than SUM and it not working for either (on a Mac as I assume you are Windows) implies something pretty basic is not working as expected.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Allignment of numbers with parentheses
|
RussBell | Mail Merge | 2 | 10-28-2016 05:51 AM |
|
Is there a quick way to remove the dashes and parentheses from phone numbers?
|
Stacy | Excel | 2 | 09-12-2014 07:03 AM |
| How to extract only numbers from a STRING? | Learner7 | Excel | 3 | 07-02-2013 06:25 AM |
| Extract Numbers from Zip Code | Karen615 | Excel | 3 | 09-21-2011 06:54 AM |
| Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
Mac OS X 
Office 2011 for Mac
Hybrid Mode