Try...

=IF(COUNTIF($E$4:$E$17,G4)=1,SUMIF($E$4:$E$17,G4,$C$4:$C$17),"")