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?
Bookmarks