That returns the count of the number of times that team appears - I need it
to show the team name.

"Roger Govier" wrote:

Hi

If the team names are in column A
=COUNTIF(A:A,"Team Name")

Replace Team name with the actual team required, or a cell reference
holding the team name

--
Regards

Roger Govier


"JDB" wrote in message
...
Hi,

I have a sheet of data with team names in one column and the data
relating
to these teams in other columns. Each row is a scored telephone call
taken by
individual team members. What I need to do is count the number of time
each
team name appears on the list and display this on another 'Results'
worksheet. I have a pivot table that can give me that, but I need to
display
the data on the 'Results' sheet which contains other data too.

Any ideas?