Forum Discussion

Jacek Warchol's avatar
Jacek Warchol
Copper Contributor
Nov 24, 2017
Solved

How to make excel count values depending on selected category?

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.

 

excel

2 Replies

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Nov 25, 2017

    Jacek,

     

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

     

    • Jacek Warchol's avatar
      Jacek Warchol
      Copper Contributor
      Nov 25, 2017

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

      Thank you very much!

       

      BR, Jacek.

Resources