Count the number if times a unique number appears in a list

[p45cal]

Yes, the OP's question, seems contradictory:

just how many times a given container number is displayed when it it covers or falls under the same number from column B

and

cell B2 & B3 have same number and column C2 & C3 have same number so the unique count of the container number in Cell D2 & D3 is actually only 1

Surely it's possible for the OP to upload a small file with expected results?