name wise Text summary
 

Hi all,
This is Charlie again to bother you.
I remember last time you gave me solution for my excel query.
I hope you will help me to solve this as well.
Name hit1 hit2 hit3
a x e a
c y d b
b t u h
a b t e
c t s w
a f t j
b e i r

Which advance function of excel can be used to find what 'a' is
having (sum of text) in each column(hit1,hit2,hit3,hit4) data like
"=sumproduct(--(A$2:A$7="a"),--($B$2:$B$7=1))" to get product of numbers?