# Countifs Function, Words in a cell Criteria

1. ## Countifs Function, Words in a cell Criteria

I have strained my brain on this for a while, and i need help.

Similar to a countifs function, but the problem resides where i need to match certain words in a cell to another.
Attached is an example of what i am working on, it will make more sense when you see it.

I tried using an array formula, but i had no success.Count if.xlsxCount if.xlsx

2. ## Re: Countifs Function, Words in a cell Criteria

use
=COUNTIF(B:B,"=*"&[@Project]&"*")

but i get an answer of 4 in column B - as there are 4 occurrence of Cat Doorstop. in the column
Why do you say 2?

3. ## Re: Countifs Function, Words in a cell Criteria

Maybe this in 2007:
Formula:
`Please Login or Register  to view this content.`

But I also get 4 for the first two answers.

 F G H I 2 Project Required to Completed Project Answers I need 3 Cat Doorstop. 4 <-- 2 4 Cat Jaida. 4 <-- 1 5 Cat KCDB Mounts. 1 <-- 1 6 "Other". 5 <-- 5

Regards, TMS

4. ## Re: Countifs Function, Words in a cell Criteria

Thanks for the help guys. Just what I needed. The reason I needed 2 was because I needed it to match with the third column as well for "Yes". But that is easily done.

Here is the formula: =COUNTIFS(B:B,"=*"&[@Project]&"*",C:C,"yes")

and I needed:
2
2 (not 1)
1
5

Thanks again.

5. ## Re: Countifs Function, Words in a cell Criteria

You're welcome. Thanks for the rep.

6. ## Re: Countifs Function, Words in a cell Criteria

your welcome, thanks for the rep

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1