Counting Values

  • Thread starter Thread starter Neil M
  • Start date Start date
N

Neil M

I have a spreadsheet that has a single column of
alphanumeric data. I want to "count" how many times the
value "Apple Tree" appears. For example, I have 433 rows
of data, and "Apple Tree" appears 55 times. I have tried
using COUNT, COUNTA, DCOUNT, and DCOUNTA without success.
I want to return the count of "55". This HAS to be simple
to do. Any easy suggestions?
 
Hi Neil,

=COUNTIF(A:A,"Apple Tree")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
One way:

=COUNTIF(A:A,"Apple Tree")


If Apple Tree may be embedded in other text:

=COUNTIF(A:A, "*Apple Tree*")
 
Back
Top