Two Condition "Countif" with a Twist

[Dave]

This is a variation on the usual "countif" with two conditions
question.

I have two columns of data. One contains a category number, the other
a string of text comments. Example:

A B
1 1010 "ps, le, te, ss"
2 1010 "ps"
3 1020 "ss, te"
4 1020 "le, ps"

I'd like to count the number of cells with a specific category number
in Column A that contain certain text in Column B.

Several previous posts have described how to use a "Sum" array
function handle counting with two conditions. This method would look
something like this:
{=sum((A1:A4=1010)*(B1:B4="le"))}

Unfortunately, this doesn't work properly. None of the cells in Column
B actually have the value "le". Using wildcards doesn't seem to work
either (eg: "*le*"). Any advice?

Thanks,
Dave

 

[Jerry W. Lewis]

Multiple conditions are handle with SUMIF (or SUM, but SUM must be array
entered).
=SUMIF((condition1)*((condition2)+(condition3)))
counts the number of times that condition1 occurs AND (*) either
condition2 OR (+) condition3.

For your twist, use
ISNUMBER(FIND("le",B1:B4))
as the condition.

Jerry