M
Madduck
Hi Team,
was wondering if you could help with this one.
Summary Sheet :
A B
1 Team # referral calls
2 Red Team ??
3 Blue Team ??
4 Green Team ??
7 All team members # referral calls
8 Adam =COUNTIF(Data!$G:$G,B14)
9 Bill =COUNTIF(Data!$G:$G,B14)
10 Alison =COUNTIF(Data!$G:$G,B14)
11 Allana =COUNTIF(Data!$G:$G,B14)
Lookup Sheet
A B
1 Name Team
2 Adam Red
3 Bill Red
4 Alison Blue
5 Allana Green
I am trying to have a "Team Totals" table at the top of the individual
totals, withour having to reference the team next to the individual on that
page. Instead I have a lookup sheet that allocates the team to the people....
in "Excel talk" in cells B2:B4
=sum(B7:B11) if B4 = VLOOKUP(B14,'Lookup sheet'!$A$2:$B$5,2,FALSE)
of course that will not work for a few reasons, one being the lookup in not
set up for an array >.<
any ideas?
was wondering if you could help with this one.
Summary Sheet :
A B
1 Team # referral calls
2 Red Team ??
3 Blue Team ??
4 Green Team ??
7 All team members # referral calls
8 Adam =COUNTIF(Data!$G:$G,B14)
9 Bill =COUNTIF(Data!$G:$G,B14)
10 Alison =COUNTIF(Data!$G:$G,B14)
11 Allana =COUNTIF(Data!$G:$G,B14)
Lookup Sheet
A B
1 Name Team
2 Adam Red
3 Bill Red
4 Alison Blue
5 Allana Green
I am trying to have a "Team Totals" table at the top of the individual
totals, withour having to reference the team next to the individual on that
page. Instead I have a lookup sheet that allocates the team to the people....
in "Excel talk" in cells B2:B4
=sum(B7:B11) if B4 = VLOOKUP(B14,'Lookup sheet'!$A$2:$B$5,2,FALSE)
of course that will not work for a few reasons, one being the lookup in not
set up for an array >.<
any ideas?