help for simple formula of summary based on input criteria.
 

hi all,

greetings.

xlsx2016

my sheet 1 data
col( A ) col( B ) col( C ) col( D )
row 1 A 9 0 10
row 2 B 0 ME 0
row 3 C 0 0 10
row 4 D 0 0 10
row 5 E 9 0 0
row 6 FF 0 0 10
row 7 G 0 ME 0
row 8 HH 0 ME 0
row 9 I 0 0 0
row 10 J 0 0 0
row 11 K 0 0 10
row 12 LL 9 0 0

Input_Criteria (Search range B1:D12) "=formula" Summary_Result list taken from Col(A)
9 "=" A,E,LL.
ME "=" B,G,HH.
10 "=" A,C,D,FF,K.

hope its easy using the built-in worksheet function(s).

TIA
driller3_banter