Sum of each different categories in on one column

Tsholanang Nthutang

Hi, 

I have 2 columns, one with a product description(Different products on a 1000 cells) and the other column it is their individual value. May you assist on how to get a sum of, say "shirts" only from the product description column?

Andrée Starå

Hi Tsholanang,

Try something like this.

Replace "Shirts" with what you want to SUM.

=SUMIF([Product Description]:[Product Description]; "Shirts"; [Individual Value]:[Individual Value])

The same version but with the below changes for your and others convenience.

=SUMIF([Product Description]:[Product Description], "Shirts", [Individual Value]:[Individual Value])

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting