So you want count if and sum if based on Re-Sign?

You can use this.

=COUNTIF($B$2:$B$37,$B$2)

=SUMIF($B$2:$B$37,"Re-Sign",$C$2:$C$37)

And don't understand why Left/Right is required when you have Re-Sign as is? Am I missing something?