Count cells in a column with certain criteria

2 other solutions:

somproduct (see the example => the green cel)

filter in combination with subtotal (see the example => the gold cel)

Do you have questions, just ask.