software

I have a column containing part numbers. I want to count the number of times
a part beginning with quot;RY...quot; occurrs. However, I wish to exclude the parts
that end with quot;...GBMKquot;.

Could this be done easily with COUNTIF?

Any suggestions?

If your data is in B11:B14:

=SUMPRODUCT(--(LEFT(B11:B14,2)=quot;ryquot;),--(RIGHT(B11:B14,4)lt;gt;quot;gbmkquot;))

Modify your range as necessary. Sumproduct cannot accept entire columns
such as A:A or A1:A65536, but A1:65535 is okay.

quot;djDaemonquot; wrote:

gt; I have a column containing part numbers. I want to count the number of times
gt; a part beginning with quot;RY...quot; occurrs. However, I wish to exclude the parts
gt; that end with quot;...GBMKquot;.
gt;
gt; Could this be done easily with COUNTIF?
gt;
gt; Any suggestions?