L
Lance
Assuming that column E can contain CON or P2K in a cell
(not "CON P2K")
=SUMPRODUCT((('receiving data'!E2:E40000="CON")+
('receiving data'!E2:E40000="PK2"))*(ISNUMBER(SEARCH
("*X*",'receiving data'!Q2:Q40000))))
(not "CON P2K")
=SUMPRODUCT((('receiving data'!E2:E40000="CON")+
('receiving data'!E2:E40000="PK2"))*(ISNUMBER(SEARCH
("*X*",'receiving data'!Q2:Q40000))))