Thank you, thank you, thank you!!!

Have a great weekend Biff,
Amy




Biff wrote:
Hi!

Try this:

Use 2 cells to hold the criteria:

C1 = Assembly
D1 = CNC

=SUMPRODUCT(--(A1:A100=C1),--(ISNUMBER(SEARCH(D1,B1:B100))))

Biff

I need to be able to count how times the word 'CNC' occurs in column B,
only
[quoted text clipped - 46 lines]
Machining Quality
Assembly Quality

--
Thank you,
Amy@H-D