Excel formula to count cells with specific text

Greetings

=SUMPRODUCT((ISNUMBER(SEARCH("9P to 9A",A4:A1000)))*(B4:AC1000={"K"}))

This formula counts "1" every time the string "K" is found in a range of rows which also contain another cell value "9P to 9A". Works great as far as I've found, although, it's probably a little complicated.

Now I also want this formula to search for "Km" in addition to "K".

I tried these and they didn't work:

=SUMPRODUCT((ISNUMBER(SEARCH("9P to 9A",A4:A1000)))*(B4:AC1000=OR({"K"},{"Km"}))) <<value not found error
=SUMPRODUCT((ISNUMBER(SEARCH("9P to 9A",A4:A1000)))*OR((B4:AC1000={"K"}),(B4:AC1000={"Km"}))) <<gave an incorrect result

I've attached an edited version of the workbook.

Can someone point me in the right direction?

Thank you!