help me to sort out data by text
 

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?

help me to sort out data by text
 

Do you mean

=sumproduct(--(A$2:A$7="a"),--($B$2:$B$7="t"))
--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Charlie" wrote in message
...
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?

help me to sort out data by text
 

Yes bob,You understood correct way.
I want to do that way only.
thanks.

"Bob Phillips" wrote:

Do you mean

=sumproduct(--(A$2:A$7="a"),--($B$2:$B$7="t"))
--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Charlie" wrote in message
...
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?