SUMIF in Clementine Derive Node?

As the title asks, is it possible to do a sumif command based on certain criteria in a derive node

For example if I has the following fields
Field_1 contains Group (String)
Field_2 contains Participant (String)
Field_3 contains Score (Range)

How do I create a Field_4 to give a % of total score for each participant against the group where scores above 0 only

In excel it would be an array formula


Explained in english this translates
If the participants score is 0 then set to 0, otherwise
sum the scores greater than 0 for the group containing this participant. Divide the participants score by this sum to give a %