Note that you will only be able to do "OR" conditions twice within the COUNTIFS. The first array constant is horizontal while the second array constant is vertical.

=SUM(COUNTIFS(myrange1, {1,2,3} , myrange2, {1;2;3} ))