I am not certain you need a sumproduct. It sounds like you just need a conditional sum to add up column f, if your conditions in columns C, G, and AV are met.

=+SUMIFS($F$3:$F$8,$C$3:$C$8,"Undone",$g$3:$g$8,100%,$av$3:$av$8,">=0",$av$3:$av$8,"<=500")

Maybe you are multiplying column G x column AV x column F. If so, here is that formula.

+sumproduct(if($C$3:$C$8="Done",if($g$3:$g$8=100%,if($av$3:$av$8>=0,if($av$3:$av$8<=500,$g$3:$g$8)))),if($C$3:$C$8="Done",if($g$3:$g$8=100%,if($av$3:$av$8>=0,if($av$3:$av$8<=500,$av$3:$av$8)))),if($C$3:$C$8="Done",if($g$3:$g$8=100%,if($av$3:$av$8>=0,if($av$3:$av$8<=500,$f$3:$f$8)))))

***Remember, this is an array function, so you need to Ctrl-Shift-Enter after you put in the formula

Good luck