Excel

1. Countifs with multiple criteria in single criteria range

=SUM(COUNTIF(M1:M12,{“A”,”B”,”C”}))
=SUM(COUNTIFS(M1:M12,{“A”,”B”,”C”},B1:B12,{“D”,”E”,”F”))