Welcome!

Sum of each different categories in on one column

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?

Find more posts tagged with

Support

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Delete
How can I delete old sheets I no longer use from my account?
How do I get a dashboard chart based on a report to display as a donut chart?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…