Need help with SUMIFS formula

example from post#1 and from post#3 are exactly the same (with different order only)

so maybe select whole range, use Ctrl+T (it will change your range to Excel Table) then sort by first column (handler or whatever)

this is your source data (post#1) as ExcelTable, sorted
column1 by A-Z
column2 by Z-A
and the result is like in post#3

Brett Gaines	Sassy	660
Char Edward	Tuff	460
Dave Jones	Mouse	120
Ed Walker	Dave	420
Jim Davis	Dave	60
Jim Smith	Slink	20
Jim Smith	Slik	220
Joe Nellis	Bullet	560
Kate North	Blue	320
Sam Smith	Pete	360
Sam Smith	Liz	160
Tom Williams	Duncan	60