Sumproduct help

[Spraggs]

Could anyone please assist me with the following:
In cell E2 I'm after a sumproduct where PM01 is in column A, QSE or QSJ is in column B and 101 is in column C. Also what would the formula be if I only wanted to look for MIN in column B with PM02 in column A and 102 in column C.
Many Thanks Jase

Book1
	A	B	C	D	E
1	Order	Location	Type		QSE or QSJ &101
2	PM01	1042-QSE-MAN-L3C-RT032	204
3	PM01	1001-MIN-MAN-SYR-PUU113	201
4	PM02	1042-QSE-MAN-16F-WI012	101
5	PM01	1042-GSV-BLD-EFC-BD006	202
6	PM02	1001-SIB-SER-BLD-BUS401	204
7	PM01	1042-QSE-MAN-L01-DI009	101
8	PM01	1001-MIN-MAN-FON-PUN119	203
9	PM02	1042-QSE-MAN-L04-PR004	102
10	PM02	1001-MIN-MAN-SYR-PUU111	102
11	PM01	1001-MIN-MAN-FON-PUN116	201
12	PM01	1001-SIB-SER-BLD-BUS401	205
13	PM01	1001-MIN-MAN-M12-TEP122	203
14	PM01	1001-MIN-PKW-B11-BXE111	201
15	PM01	1001-MIN-MAN-SUG-CVG091	202
16	PM01	1042-QSJ-MAN-L14-PR014	101
17	PM01	1042-QSE-MAN-L3D-TE011	202
18	PM02	1042-QSE-MAN-L3B-FR013	204
19	PM02	1042-QSE-MAN-L01-DI008	101
20	PM01	1042-QSJ-MAN-L01-DI013	203
21	PM01	1042-QSJ-MAN-L01-DI014	102
22	PM01	1042-QSJ-MAN-L01-DI021	102
Sheet1

 

[barry houdini]

Try

=SUMPRODUCT(--(A2:A100="PM01"),--(ISNUMBER(SEARCH("QSE",B2:B100))+ISNUMBER(SEARCH("QSJ",B2:B100))>0),--(C2:C100=101))

and

=SUMPRODUCT(--(A2:A100="PM02"),--ISNUMBER(SEARCH("MIN",B2:B100)),--(C2:C100=102))

 

[Spraggs]

Brilliant Barry.
Thanks very much.