Excel formula to count cells with specific text

Greetings

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

I've attached an edited version of the workbook.

Can someone point me in the right direction?

Thank you!

Hi,

It would have assisted greatly if you had uploaded a workbook rather than a picture (as per the guidance notes in the forum rules), but in the absence of a workbook to test perhaps

Please Login or Register  to view this content.

or even

Please Login or Register  to view this content.

Regards