For a contiguous range,

=SUM(COUNTIF(A1:A20, B1:D1))

Otherwise,

=SUM(COUNTIF(A1:A20, CHOOSE({1,2,3}, B1, C2, D3)))

Either must be confirmed with Ctrl+Shift+Enter.