VLOOKUP with a SUM

[wyte32]

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

[mancubus]

Hi.

You want to sum values based on one condition. So use sumif function.