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 ...
  • Detlef_Lewin's avatar
    Nov 25, 2017

    Jacek,

     

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

     

Resources