You're welcome. Thanks for the feedback!
Biff
"Amy via OfficeKB.com" wrote in message
...
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
|