I couldn't come up with a clear title. Here's the question with a proper example.
Two Tables of Data:
TABLE A
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]GP[/TD]
[TD]M[/TD]
[TD]P[/TD]
[TD]A[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]80[/TD]
[TD]3040[/TD]
[TD]2320[/TD]
[TD]880[/TD]
[TD]480[/TD]
[/TR]
[TR]
[TD]Steph[/TD]
[TD]72[/TD]
[TD]2448[/TD]
[TD]1800[/TD]
[TD]576[/TD]
[TD]288[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]73[/TD]
[TD]2555[/TD]
[TD]1971[/TD]
[TD]511[/TD]
[TD]511[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]78[/TD]
[TD]2730[/TD]
[TD]1404[/TD]
[TD]780[/TD]
[TD]234[/TD]
[/TR]
[TR]
[TD]Patrick[/TD]
[TD]80[/TD]
[TD]3200[/TD]
[TD]1760[/TD]
[TD]160[/TD]
[TD]960[/TD]
[/TR]
</tbody>[/TABLE]
TABLE B
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Team[/TD]
[TD]Position[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]Houston[/TD]
[TD]Forward[/TD]
[/TR]
[TR]
[TD]Steph[/TD]
[TD]Warriors[/TD]
[TD]Guard[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]Warriors[/TD]
[TD]Forward[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]Houston[/TD]
[TD]Guard
[/TD]
[/TR]
[TR]
[TD]Patrick[/TD]
[TD]New York[/TD]
[TD]Center[/TD]
[/TR]
</tbody>[/TABLE]
I want to do SUMIF statements on Table A.
I want the SUM of all P for Names on Team Houston. We can look at Table B and see that this would be James and Chris. So this should be 2320+1404.
The simple way would be to aggregate all data into a single table, but that would get quite messy since there is a lot more data than shown in the example.
Any ideas? Thanks in advance!
Two Tables of Data:
TABLE A
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]GP[/TD]
[TD]M[/TD]
[TD]P[/TD]
[TD]A[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]80[/TD]
[TD]3040[/TD]
[TD]2320[/TD]
[TD]880[/TD]
[TD]480[/TD]
[/TR]
[TR]
[TD]Steph[/TD]
[TD]72[/TD]
[TD]2448[/TD]
[TD]1800[/TD]
[TD]576[/TD]
[TD]288[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]73[/TD]
[TD]2555[/TD]
[TD]1971[/TD]
[TD]511[/TD]
[TD]511[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]78[/TD]
[TD]2730[/TD]
[TD]1404[/TD]
[TD]780[/TD]
[TD]234[/TD]
[/TR]
[TR]
[TD]Patrick[/TD]
[TD]80[/TD]
[TD]3200[/TD]
[TD]1760[/TD]
[TD]160[/TD]
[TD]960[/TD]
[/TR]
</tbody>[/TABLE]
TABLE B
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Team[/TD]
[TD]Position[/TD]
[/TR]
[TR]
[TD]James[/TD]
[TD]Houston[/TD]
[TD]Forward[/TD]
[/TR]
[TR]
[TD]Steph[/TD]
[TD]Warriors[/TD]
[TD]Guard[/TD]
[/TR]
[TR]
[TD]Kevin[/TD]
[TD]Warriors[/TD]
[TD]Forward[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[TD]Houston[/TD]
[TD]Guard
[/TD]
[/TR]
[TR]
[TD]Patrick[/TD]
[TD]New York[/TD]
[TD]Center[/TD]
[/TR]
</tbody>[/TABLE]
I want to do SUMIF statements on Table A.
I want the SUM of all P for Names on Team Houston. We can look at Table B and see that this would be James and Chris. So this should be 2320+1404.
The simple way would be to aggregate all data into a single table, but that would get quite messy since there is a lot more data than shown in the example.
Any ideas? Thanks in advance!