|
|
#3
04-23-2019, 02:40 PM
|
|||
|
|||
Extract numbers from parentheses and add them up
Well, that's the pits! I copied the formula directly fro the spreadsheet and it gives me zero. I did
=SUMPRODUCT(Q74:Q91)Q74:Q91 is where I did the fill down to see that the extract was working properly. The SUMPRODUCT above gave me 84, which is correct. The items to be summed are all entered from the keyboard, so they are not computed. I've got Office 2011 on my Mac. Is that the issue? 
|
|
|
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
Threaded Mode