count function

  • Thread starter Thread starter Mycotopian
  • Start date Start date
M

Mycotopian

I was hoping someone could help me. I have a sheet that is 3 colums b
100 rows. The colums are team leader , team member and transactio
number. I just want to count how many team members are on each team
The problem I run into is that the team members are mentioned multipl
times because they have multiple transactions. Any ideas
 
I think these are the 2 functions I want to do I am just having troubl
nesting them correctly

=(COUNTIF(B:B,"Barry Palmer")

(DCOUNTA($C$1:$C$999,1,$L$6:$L$7
 
Use the advanced filter and extract unique team member names to another
location and then use countif
 
The advanced filter is not working for some reason. I put in all my
criteria and nothing happens.
 
Assume your Team Leaders are in column C, then in D2 put the Unique Tea
Leaders (and down column D until all listed). In E2 put this formula:

=COUNTIF($C$1:$C$999,D2)

and copy down column E as far as Column D goes (double-click the heav
cross hairs when it is in the lower right corner).
 
Shades,

That gives me the total number of entries for each team leader but
within those entries there are duplicate names. My goal is to count how
many team members there are so I only want to count each name once. Any
other ideas?
 
Okay, let's assume

column A, Team Leaders
Column B, Team Members

Put unique list of Team leaders across starting at G1
and unique Team Members down column F beginning at F2

Then in G2 put this formula (and copy across to number of Team Leaders,
and copy down to rows of unique Team Members)

=SUMPRODUCT(($A$2:$A$17=G$1)*($B$2:$B$17=$F2))

This grid will give you the numbers and identity of each team member
under each Tema Leader.
 
Back
Top