Count in cells based on multiple criteria in other columns

New forum member here, thanks for letting me post my problem. I do not know if this will require a VBA or macro, or if it can be done with a nested formula. Open to any solutions.

I'm building a template that will work on multiple sheets to do a count based on multiple criteria. I've attached a sample workbook, just deleted all the non-relevant data. There are three columns I want to place the count in (D, J and R), but I will reference only R here to try and make it easier to understand.

If number found in column X or AM is found in cell O2, AND column V or AK contains "N", then count in column R.

So for instance, # 27 (column X) has a value of "N" in column V. How many times are numbers with N values found in cell O2? And O3? etc. The count would be placed in column R.

I've manually added yellow hi-lited numbers in rows 2 and 3 for column E, K and S so you can see the numbers that should end up being calculated for those cells immediately the their left.

A couple things to keep in mind... the strings in column B, H and O will always end without a semi-colon. They will end with a digit, or possibly X.

(Attached file removed after solved.)

Please try at D2
=SUMPRODUCT(ISNUMBER(FIND($X$6:$AM$55,B2))*($V$6:$AK$55="N"))