COUNTIFS and SUMIFS

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?

Try Using a Pivot Table..

See the attached file..

Here are different calculations relating to your worksheet:
Reason for Non Renewal:
Count:

Formula:

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

or ARRAY formula entered with Ctrl + Shift + Enter

Formula:

=COUNT(IF($B$2:$B$37=G19,$C$2:$C$37))

Sum:

Formula:

=SUMIF($B$2:$B$37,G12,$C$2:$C$37)

or

Formula:

=SUMPRODUCT(($B$2:$B$37=G19)*($C$2:$C$37))

The formulae for Package Types are the same except column A replaces Column B

Pivot tables are also used.

The enclosed file has the results.