I'm trying to sum up the numbers on the LEFT of the parenthesis. This example would nomally return 5.

I tried using this fomula: =sumproduct(--(LEFT(C1:C30),1))) but i get a #VALUE ! error.

Right now I mostly have single digits on the left of the parenhesis and within as well but it's not excluded that I might have double digits in the futur.

Any help?

--BONUS questions : Would it also be possible to count Inside the parenthesis ?

I might be interested in finding out the sum of it too.

Thanks