=COUNTIF(G:G,D2)

--
__________________________________
HTH

Bob

"Paul" wrote in message
...
I'm trying to put together a formula that will count the number of times
the
data in cell D2 appears in column G.
Thanks!