How can I use Count and Sum function in one cell from table below?

Question

I am looking to count and sum the cells in the example below. I want the result to reflect the total number of groups as well as total number of those participated in the groups. For example, the result should be 3 (20). This reflects there were 3 groups held, with a total of 20 participants among the groups. How can I create a formula that counts the "1"s and Sums the # in parentheses?

Intervention
1 (9)
1 (4)
1 (7)

Answer 1

Check a formula:

=COUNTIF(A1:A3,"1 (*") & " (" & SUM(--TEXTBEFORE(TEXTAFTER(A1:A3,"(",,,,""),")",,,,0)) & ")"

Use the required range instead of A1:A3.