Google Sheets Formula for Summing Bracketed Numbers
Budget: $10 – $30 USD
I need an experienced Google Sheets expert to create a formula for me to sum numbers contained within brackets in a single cell. The numbers are separated by words and semi-colons. The formula should also account for decimal numbers, which should be included in the sum.
here is an example of a cell:
Dorp ( 27632) 34540; La Cotte ( 7433) 10390; Welgeluk (4000 ) 5000; Beach Villa (10285 ) 12100; Botlierskop (34680 ) 56040; Pure Sea (13760 ) 17200; ATG (10485) 11785
I am currently adding the numbers in brackets manually to input into the next cell, but want a formula to add these numbers
here is an example of a cell:
Dorp ( 27632) 34540; La Cotte ( 7433) 10390; Welgeluk (4000 ) 5000; Beach Villa (10285 ) 12100; Botlierskop (34680 ) 56040; Pure Sea (13760 ) 17200; ATG (10485) 11785
I am currently adding the numbers in brackets manually to input into the next cell, but want a formula to add these numbers