Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2019, 09:29 PM
xor xor is offline Extract numbers from parentheses and add them up Windows 10 Extract numbers from parentheses and add them up Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,101
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


Same remark as I gave in #2.
Attached Files
File Type: xlsx foo_2.xlsx (10.8 KB, 9 views)
Reply With Quote
  #2  
Old 05-06-2019, 01:04 PM
pokeyarw pokeyarw is offline Extract numbers from parentheses and add them up Mac OS X Extract numbers from parentheses and add them up Office 2011 for Mac
Novice
Extract numbers from parentheses and add them up
 
Join Date: Apr 2019
Posts: 5
pokeyarw is on a distinguished road
Default 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.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract numbers from parentheses and add them up Allignment of numbers with parentheses RussBell Mail Merge 2 10-28-2016 05:51 AM
Extract numbers from parentheses and add them up 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 02:08 AM.


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