You can achieve the effect of CLAMP(value, min, max) with

=IFERROR(max-SQRT(max-IFERROR(SQRT(value-min)^2+min,min))^2,max)

which is compatible with ARRAYFORMULA and uses value only once. Explanation:

1. SQRT(value-min)^2+min returns value if value>=min, and gives an error otherwise.
2. IFERROR returns the first argument, unless an error occurred in it, which case it returns the second
3. Thus, IFERROR(SQRT(value-min)^2+min,min) clamps the value from below by min.
4. The other steps do a similar thing with max.

The above formula can be simplified, reducing the references to max and min from three to two of each:

=max-IFERROR(SQRT(max-min-IFERROR(SQRT(value-min)^2,0))^2,0))

Short answer

Alternative 1

Instead of {"First Value;"Second Value"} write ={"First Value,"Second Value"} in cells D2 and D3 in the example provided in the question.

Then, instead of using a category names reference of the form D2 use the D2:D3 reference form.

Alternative 2

Instead of {"First Value;"Second Value"} write First Value;Second Value in cells D2 and D3 in the example provided in the question.

Then, instead of D2 as the reference in the formula use =SPLIT(D2,";")

Explanation

1. When an array in wrote in a cell without a leading formula operator (= or +) it is interpreted by Google Sheets as a string instead as an array.

Alternative 1

2. As the OP want to put one array in each row, instead of using a row separator, use a column separator.

3. As the array values are in a 1x2 range the reference to use in the formula should be of the form D2:E2. The formula will be like the following

   =ArrayFormula(sum(sumif(A:A, D2:E2, B:B)))

Example

Alternative 2

In order to make easier to convert a string to an array it's suggested to remove the enclosing braces and the quotes, otherwise more functions will be required to remove them and will make the spreadsheet more complex and slow.

The formula will be like the following:

=ArrayFormula(sum(sumif(A:A, SPLIT(D2,";"), B:B)))

Example