Count numbers if cell to left has data

I am trying to count the number of times a number in column G appears IF it has data entered into the cell to the left.

\1

So the above example would output 2.


I have come up with =COUNTIF(G:G, L2) to count all the times 414 is used. What do I need to add to this?

Thanks for the welcome and thanks for the quick help. That is just what I needed.