COUNTIFS and SUMIFS

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.