sum max vaules with criteria from 2d array

[johnnash]

Hello all,

Is this possible

Think as left column has criteria text, and other columns have values,

I want to get max value from each row matched with criteria, sum all of it.

 

[johnnash]

Workbook.xlsx
	A	B	C	D
3	john	66	52	2
4	michael	68	94	47
5	dorothy	8	2	57
6	eric	82	65	85
7	homer	85	95	59
8	john	30	90	83
9
10
11
12	sum of john's max values
13	66+90
Sheet2