Sum If Cell Contains "this word", but not "this word"

[south0085]

I have a list of part types in column E1:E57. In cell F59, I want to add up all the ones that include the word "Cover", but I don't want it to include any that contain the word "service". Like this:

Sheet1

	E	F
1	Mitsubishi Service Cover - ZC	28
2	989A COVER	56
3	B12P Cover	87
4	Toyota Service - 989A Cover	100
5	Toyota Service Cover	500

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:190px;"><col style="width:70px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4



So...the formula return a total of: 143

Thank you for your help.

 

[VBA Geek]

Excel 2013/2016
	A	B	C	D	E
1	Mitsubishi Service Cover - ZC	28
2	989A COVER	56
3	B12P Cover	87
4	Toyota Service - 989A Cover	100			143
5	Toyota Service Cover	500
6
Sheet1

Cell Formulas
Range	Formula
E4	=SUMIFS(B1:B5,A1:A5,"*cover*",A1:A5,"<>*service*")

 

[south0085]

Excel 2013/2016

	A	B	C	D	E
1	Mitsubishi Service Cover - ZC	28
2	989A COVER	56
3	B12P Cover	87
4	Toyota Service - 989A Cover	100			143
5	Toyota Service Cover	500
6

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula E4 =SUMIFS(B1:B5,A1:A5,"*cover*",A1:A5,"<>*service*") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thank you much! The <> is the part I couldn't figure.