Advance function of excel to get sorted data
 

Name hit1 hit2 hit3 hit4
a 1 2 4 1
c 2 2 2 2
b 2 2 3 3
a 1 1 2 1
c 1 2 1 2
a 3 1 1 1
b 2 2 2 2

Which advance function of excel can be used to find How many times 'a' is
having '1' in each column(hit1,hit2,hit3,hit4) data?

Advance function of excel to get sorted data
 

See response in worksheet.functions


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Charlie" wrote in message
...
Name hit1 hit2 hit3 hit4
a 1 2 4 1
c 2 2 2 2
b 2 2 3 3
a 1 1 2 1
c 1 2 1 2
a 3 1 1 1
b 2 2 2 2

Which advance function of excel can be used to find How many times 'a' is
having '1' in each column(hit1,hit2,hit3,hit4) data?

Advance function of excel to get sorted data
 

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

repeat for the other columns.

--
Regards,
Tom Ogilvy


"Charlie" wrote:

Name hit1 hit2 hit3 hit4
a 1 2 4 1
c 2 2 2 2
b 2 2 3 3
a 1 1 2 1
c 1 2 1 2
a 3 1 1 1
b 2 2 2 2

Which advance function of excel can be used to find How many times 'a' is
having '1' in each column(hit1,hit2,hit3,hit4) data?

Advance function of excel to get sorted data
 

Hi Tom,
This is Charlie again to bother you.
I remember last time you gave me solution for my excel query.

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 text 'a' is
having 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?
"Tom Ogilvy" wrote:

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

repeat for the other columns.

--
Regards,
Tom Ogilvy


"Charlie" wrote:

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 text 'a' is
having in each column(hit1,hit2,hit3,hit4) data?