Excel If Statement ??

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
Quick One for the guru's:

I am trying to write an IF/Count statement that goes like this:

Count the number of cells in Column A that contain the word "best". Any
clues as to the best way to go about this?

Clint
 
I am trying to write an IF/Count statement that goes like this:
Count the number of cells in Column A that contain the word "best". Any
clues as to the best way to go about this?

As a worksheet function:

=COUNTIF(A:A,"=best")

HTH,
Merjet
 

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

Back
Top