Excel 2007 : Counting specific words in cells containing more than one word

**JPLNG** · 04-26-2011, 11:22 AM

Hello all,

Need a bit of help here in order to work out a formula, i have been playing around with countif and LEN but i cant seem to get the correct formula.

The issue:

I have the following information in column A. So A1:A5

Column A

1NA.1 - Commute to work
2NA.1 - Commute to work
3NI.1 - Task Planning
4UN.2 Worked on Marked E-mails
5UI.1 - SLC contract Agreement

I want to find out how many times NA.1 appears in this range of data. So obv it occurs twice but whats the formula?

Any help would be appreciated.

**NBVC** · 04-26-2011, 11:24 AM

Does this do it?

=COUNTIF(A1:A5,"*NA.1*")

**JPLNG** · 04-26-2011, 11:33 AM

Originally Posted by NBVC

Does this do it?

=COUNTIF(A1:A5,"*NA.1*")

I think I was trying to over complicate it all, legend it worked, thank you for your help.

Cheers Buddy

**NBVC** · 04-26-2011, 11:57 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save