Sum unique values with multiple criteria on the same table

[ASMASM85]

I have a table with three columns and I want to create a 4th one that will sum the score of all unique actions for a single week.

in the the attached image I placed the 4th column ("Score") with the calculation it should have.

can someone please help me to construct a formula that can preform this calculation ?

Screenshot at Jul 03 09-24-23.png

[davsth]

With a helper column one way is to create a column of 1/countifs(a:a,a1, b:b, b1) this gives you a fraction for the number of times it appears

sumproduct((b1:b1000=b1)*(e1:e1000)*(c1:c1000)) should give you the value

where b is week
c is values
e is the helper column

change , to ; if required

[ASMASM85]

Thanks!! that's work