Thread: Extract numbers from parentheses and add them up
View Single Post
 
Old 04-23-2019, 02:40 PM
pokeyarw pokeyarw is offline Mac OS X Office 2011 for Mac
Novice
  
Join Date: Apr 2019
Posts: 5
pokeyarw is on a distinguished road
Default 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?
Reply With Quote