Problem:

Columns A & B contain clothing items and their matching total sales.

We want to create a formula that will sum the sales from column B of all items except the jacket.

Solution:

Use the SUMIF function as shown in the following formula:

=SUMIF(A2:A6,”<>Jacket”,B2:B6)

**Screenshot // Sum Total Sales Except for One Specified Item**

Thanks!

Appropriate solution..