How to make excel count values depending on selected category?

[Jacek Warchol]

Good day,

I'm a beginner, sorry for posting such a question, I've been trying to find a solution for a couple of hours, with no luck :(

I input values (prices) in B column, and in D column I assign categories (selected from a list).

In other tab I would like to sum values assigned to selected categories (not count how many times this category has been selected, but sum all values assigned to it!)

How do I do it? :) What's the magic formula?

Thank you.

[#2 · Accepted solution]

Jacek,

you could use a pivot table, SUMIFS(), SUMIF() or SUMPRODUCT().

[#3]

Your answer got me on right track, and I found what I was looking for.

Thank you very much!

BR, Jacek.