Using SUMIF to gather the info that doesn't match

Post a sample workbook with any confidential data

Punnam

The upload isn't showing, so I'll copy/paste a short example

MW MWh
Accokeek 1 0 0.00
Bannister 11 0.08693 128.02
Bensville 21 0.05071 72.43
Bertha 11 0.0131 16.14
Bertha 12 0.228765 284.04
Bolton 23 0 0.00
Cedarville 1 0.0225 35.93
Cedarville 2 0.06104 88.37
Dukes Inn 22 0.03168 49.11
Dukes Inn 23 0.0099751 13.55
Other


Bertha 21 0 12,320
6765 Lex Park 0 33,141
Bertha 11 4 4,928
LaPlata 11 5.43 8,131
Piscataway 23 3.42 4,213
La Plata 21 4.37 5,384
Hollywood 11 7 8,624
Bertha 11 9.1 11,211
Dukes Inn 23 6.65 8,624
Dukes Inn 23 3.325 4,928
Bannister 24 3.6 4,435
Bertha 12 13.4 16,509


The top uses my sumif to add values in bottom set. If there is a name in the bottom set that does not match the top, I want it added into the row labeled other.