Try something like this:

With a list in A1:A10

B1: =COUNTIF(A1:A10,"RY*")-COUNTIF(A1:A10,"RY*GMBK")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"djDaemon" wrote:

I have a column (C) that contains several part numbers (which are comprised
of text and numbers). I want to sum all the occurences of "RY..." cells,
excluding those which end with "...GBMK".

Is there an easy way to do this?