Hello all, how can I do this:

I have names in column A (cell 3 till 100), and I want to count them.
But, i want that my output shows like this:
f.ex.:

madonna 12 (entrys)
abba 8
50 cent 3
etc.

Hope that someone can help me.
Sorry for my bad english.


--
Narkom
------------------------------------------------------------------------
Narkom's Profile: http://www.excelforum.com/member.php...o&userid=32642
View this thread: http://www.excelforum.com/showthread...hreadid=527312

Hi Narkom,
Try this:
=counta(c3:c300,"Madonna")

HTH
Kevin M
"Narkom" wrote:


Hello all, how can I do this:

I have names in column A (cell 3 till 100), and I want to count them.
But, i want that my output shows like this:
f.ex.:

madonna 12 (entrys)
abba 8
50 cent 3
etc.

Hope that someone can help me.
Sorry for my bad english.


--
Narkom
------------------------------------------------------------------------
Narkom's Profile: http://www.excelforum.com/member.php...o&userid=32642
View this thread: http://www.excelforum.com/showthread...hreadid=527312

I think you probably meant countif:

=COUNTIF(C3:C300,"Madonna") and I think the OP has the data in column A.
But that said, I probably would have used =countif(a3:a100, "abba") because I
love some of Abba's songs :)

--
Kevin Vaughn


"Kevin M" wrote:

Hi Narkom,
Try this:
=counta(c3:c300,"Madonna")

HTH
Kevin M
"Narkom" wrote:


Hello all, how can I do this:

I have names in column A (cell 3 till 100), and I want to count them.
But, i want that my output shows like this:
f.ex.:

madonna 12 (entrys)
abba 8
50 cent 3
etc.

Hope that someone can help me.
Sorry for my bad english.


--
Narkom
------------------------------------------------------------------------
Narkom's Profile: http://www.excelforum.com/member.php...o&userid=32642
View this thread: http://www.excelforum.com/showthread...hreadid=527312

Actually, come to think of it, you probably want the artist's name in a cell
and have the formula reference the cell, like this (assumes artist name in
B2):

=COUNTIF($a$3:$a$100,B2)

--
Kevin Vaughn


"Kevin Vaughn" wrote:

I think you probably meant countif:

=COUNTIF(C3:C300,"Madonna") and I think the OP has the data in column A.
But that said, I probably would have used =countif(a3:a100, "abba") because I
love some of Abba's songs :)

--
Kevin Vaughn


"Kevin M" wrote:

Hi Narkom,
Try this:
=counta(c3:c300,"Madonna")

HTH
Kevin M
"Narkom" wrote:


Hello all, how can I do this:

I have names in column A (cell 3 till 100), and I want to count them.
But, i want that my output shows like this:
f.ex.:

madonna 12 (entrys)
abba 8
50 cent 3
etc.

Hope that someone can help me.
Sorry for my bad english.


--
Narkom
------------------------------------------------------------------------
Narkom's Profile: http://www.excelforum.com/member.php...o&userid=32642
View this thread: http://www.excelforum.com/showthread...hreadid=527312

the problem is that i must show the output in sheet 2 and all the data
is in
sheet 1.
What if I dont´t know the names listed in the column A?
Thank you all for the help


--
Narkom
------------------------------------------------------------------------
Narkom's Profile: http://www.excelforum.com/member.php...o&userid=32642
View this thread: http://www.excelforum.com/showthread...hreadid=527312