I couldn't come up with a clear title. Here's the question with a proper example.
Two Tables of Data:
TABLE A
<tbody>
</tbody>
TABLE B
<tbody>
</tbody>
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
Name | GP | M | P | A | R |
James | 80 | 3040 | 2320 | 880 | 480 |
Steph | 72 | 2448 | 1800 | 576 | 288 |
Kevin | 73 | 2555 | 1971 | 511 | 511 |
Chris | 78 | 2730 | 1404 | 780 | 234 |
Patrick | 80 | 3200 | 1760 | 160 | 960 |
<tbody>
</tbody>
TABLE B
Name | Team | Position |
James | Houston | Forward |
Steph | Warriors | Guard |
Kevin | Warriors | Forward |
Chris | Houston | Guard |
Patrick | New York | Center |
<tbody>
</tbody>
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!