Counting Values

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

Bob Phillips

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)
 
J

J.E. McGimpsey

One way:

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


If Apple Tree may be embedded in other text:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top