wyte32
06-26-2014, 08:20 AM
Hello all,
When you have data in a table like this:
Child
Group
# Correct
# Incorrect
James
Group 1
5
5
Group 1 Total Correct:
x
Sarah
Group 2
8
2
Group 1 Total Incorrect:
Carter
Group 2
7
3
Group 2 Total Correct:
Tim
Group1
3
7
Group 2 Total Incorrect:
Cristy
Group 1
8
2
Cynthia
Group 2
6
4
So where the x is, I would like to figure out: Where Column 2 cells = Group 1, add how many are in the corresponding "# Correct " column. I'm assuming use a Vlookup("Group 1", B2: D7, 2, FALSE), but I need to throw a SUM function in there somehow and not quite sure where. Can someone point me in the right direction? I know it has to be fairly simple, but for some reason I can't follow the logic today lol
When you have data in a table like this:
Child
Group
# Correct
# Incorrect
James
Group 1
5
5
Group 1 Total Correct:
x
Sarah
Group 2
8
2
Group 1 Total Incorrect:
Carter
Group 2
7
3
Group 2 Total Correct:
Tim
Group1
3
7
Group 2 Total Incorrect:
Cristy
Group 1
8
2
Cynthia
Group 2
6
4
So where the x is, I would like to figure out: Where Column 2 cells = Group 1, add how many are in the corresponding "# Correct " column. I'm assuming use a Vlookup("Group 1", B2: D7, 2, FALSE), but I need to throw a SUM function in there somehow and not quite sure where. Can someone point me in the right direction? I know it has to be fairly simple, but for some reason I can't follow the logic today lol