Based on your screencap, it looks like you're trying to use SUM(COUNTIFS()):

=SUM(COUNTIF(A2:A8,{"A","B","C"}))

Row 1 is using your formula (where you made it work multiplying it by 1);

Row 2 (selected cell) is using SUM(COUNTIFS());

Row 3 is just using COUNTIFS.