COUNTA?

Paul · Jan 13, 2009

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!

Bob Phillips · Jan 13, 2009

=COUNTIF(G:G,D2)

Pete_UK · Jan 13, 2009

Try this:

=COUNTIF(G:G,D2)

Hope this helps.

Pete

Paul · Jan 13, 2009

That worked perfectly!
Thanks so much!!

Bob Phillips said:
=COUNTIF(G:G,D2)

--
__________________________________
HTH

Bob