AND function with a wildcard

[TinaMR]

Hi,

Here's what I'm trying to do...I have a list of data:

Column C Column G
Project A Iteration 1 12
Project B Iteration 1 14
Project A Iteration 2 13
Project B Iteration 2 11
Project C Iteration 1 12
Project B Iteration 3 0

In Cell A3, I've entered "Project B".

I'm trying to create a logical test that tells me True/False when the Iteration Name contains Project B and the Points are >0. The project name is variable, so I'd like to be able to reference the cell in the formula.

This is the formula I tried to use unsuccessfully
=AND(C2=$A$3&"*",G2>0)

The logical test is important as I want to filter the TRUE values in order to create a chart for Project B.

Help, please?

 

[Nebu]

Hi:

Can you upload a sample file. It is difficult to understand what you have typed above its all cluttered together.

Thanks

 

[Khalid NGO]

@TinaMR, Hi and welcome to the forum

If I understood you correctly and your data looks like:



You can use the following:

=COUNTIFS(C2,$A$3&"*",G2,">0")>0
or
=AND(COUNT(SEARCH($A$3&"*",C2)),G2>0)

If it doesn't helps, upload a sample file with expected output (as requested above).

Regards,

Edit: Wildcard not necessary:
=AND(COUNT(FIND($A$3,C2)),G2>0)

 

[TinaMR]

Thank you! The AND formula totally worked. You are a life and sanity saver.

 

[Khalid NGO]

Great...
Glad it worked, thanks for the feedback
Keep visiting.