Hi and welcome back to the forum after being away for almost 7 years

Maybe you didnt quite get the sumif() syntax right?

=SUMIF($C$5:$C$14,"deposit from games",D5:D14)*0.7-SUMIF($F$5:$F$14,70,G5:G14)