How to obtain a total sum of one column based on the criterion of another column (Excel SUM.SE Style)

[fabioargenton]

Hey guys, I want to create a calculated column that brings me the total sales quantity based on the week column, example:

 

[gaz_chops]

Welcome to the forum, try sumifs

=sumifs(QTD Range,Semana do Ano Range, Semana do Ano Cell)

e.g.
=sumifs($G$2:$G$100,$J$2:$J$100,J2)

 

[fabioargenton]

Friend, I refer to Power BI, I will add this information to the question, thank you.
Obs: No Power BI, não temos SUMIFS