Extract numbers from parentheses and add them up

		Microsoft Office Forums > Microsoft Excel > Excel
Extract numbers from parentheses and add them up

FAQ

Mark Forums Read

Thread Tools

Display Modes

05-06-2019, 01:04 PM

pokeyarw

Extract numbers from parentheses and add them up

Mac OS X

Office 2011 for Mac

Novice

Join Date: Apr 2019

Posts: 5

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.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:47 AM.