That's it! Thanks...

I also discovered that it's possible to increase the text field to "Cont:"
but there also needs to be one other change: (LEFT(I7:I24,5)="Cont:"). A "5"
needs to be added after the range to designate the length of the text.

Thanks again...

"Roger Govier" wrote:

Hi

Try the array formula
{=COUNT(IF((B7:B24=$B24)*(LEFT(I7:I24)="C"),B7:B24 ))}
Commit using CTRL+SHIFT+ENTER, do not enter the curly braces yourself, Excel
will insert them for you.

or the non-array formula
=SUMPRODUCT(--(B7:B24=B24),--(LEFT(I7:I24)="C"))

Regards

Roger Govier


JDavis wrote:
I'm trying to use a wild card in the following equation:
=COUNT(IF((B7:B24=$B24)*(I7:I24="C*"),B7:B24))
I tested the same equation with out the wild card by replacing it with the
exact text and it worked fine. What am I doing wrong?