# SUMIF in Clementine Derive Node?

#### osknows

##### New Member
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

{=IF(Z29=0,0,Z29/SUM(IF(($A$1:$A$10000=A29)*($Z$1:$Z$10000>0),$Z$1:$Z$10000)))}

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 %