Countif formulas and contains criteria

Hi Stacy

Thank you for your question

I would suggest using the dcounta function. This is a database function and requires you to create a criteria range. By simply entering all the variants of nm into this criteria range.

To create your criteria range type the heading for the column that contains your criteria and then type in the cells beneath.

You can then access the dcounta function from the paste function dialog box. It requires three arguments;

The range of the database
The Column heading of the column that contains the values that you want to count
The criteria range

I have uploaded and example which will hopefully clarify things


Regards

Stephen

Dear Stacy

Further to my colleague's response I would like to add that you can still use the countIF function and all you have to do is simply use these arguments:

=COUNTIF(C2:C6,"nm*")

* is the wildcard which means that it starts with nm. In your case I saw all the entries had nm at the start of the entry.

If it is in the middle or at the end then you may want to replace it with *nm*.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT