Can you use two array constants in a formula?

Yes you can use two arrays, but one has to be vertical & the other horizontal, like

Formula:

=SUM(COUNTIFS(C2:C5,{1,2,3},B2:B5,{"a";"c"}))

Thanks but what do you mean by vertical and horizontal?

The only difference i can see here is use of a semi colon?