Multiple row Vlookup??

[jennie90]

I have 2 tables, the first holds points transactions for users and the second should hold a sum of points for each unique user.

There can be multiple points rows for a unique user in the first table.

I want to lookup the username stored in the second table, against the username in the first table to sum all points assigned to that user.

However, I only want to sum the points where Paid = Yes

It's out of my depth but I need it. Examples of the tables are below.

Thank you!!

USERNAME	POINTS	PAID
deborah	100	yes
michael	100	yes
michael	200	yes
simon	100	yes
deborah	100	no
michael	500	no

USERNAME	POINTS
deborah
michael
simon

[Tony Valko]

Try this...


Data Range

	A	B	C
1	USERNAME	POINTS	PAID
2	deborah	100	yes
3	michael	100	yes
4	michael	200	yes
5	simon	100	yes
6	deborah	100	no
7	michael	500	no
8
9
10
11	USERNAME	POINTS
12	deborah	100
13	michael	300
14	simon	100

This formula entered in B12 and copied down:

=SUMIFS(B$2:B$7,A$2:A$7,A12,C$2:C$7,"Yes")

[AlKey]

Or you can also use this

Enter in F2 and drag it down

=SUMPRODUCT(($A$2:$A$7=E2)*($C$2:$C$7="yes")*($B$2:$B$7))

	A	B	C	D	E	F
1	USERNAME	POINTS	PAID		Name	Points
2	deborah	100	yes		deborah	100
3	michael	100	yes		michael	300
4	michael	200	yes		simon	100
5	simon	100	yes
6	deborah	100	no
7	michael	500	no