ExcelBanter - COUNTA?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - COUNTA? (https://www.excelbanter.com/excel-worksheet-functions/216350-counta.html)

Paul

COUNTA?

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[_3_]

COUNTA?

=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!

Pete_UK

COUNTA?

Try this:

=COUNTIF(G:G,D2)

Hope this helps.

Pete

On Jan 13, 4:11*pm, Paul wrote:
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!

Paul

COUNTA?

That worked perfectly!
Thanks so much!!

"Bob Phillips" wrote:

=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!

All times are GMT +1. The time now is 01:09 AM.