Table 1:
<tbody>
</tbody>
Table 2:
<tbody>
</tbody>
I would like to be able to pull the sum of an array of columns if the two criteria (name and "apples" as the example) both match.
So sum if Table 1 A3 = "Joe" AND Table 1 B2 = "Apples". But I would like the sum range to be the whole of table 2, so that it would tell me that Joe has 8 apples total. When I put the sum range as B:D or similar, it gives me the #VALUE error.
1 | A | B | C |
2 | Apples | Oranges | |
3 | Joe |
<tbody>
</tbody>
Table 2:
1 | A | B | C | D |
2 | Apples | Oranges | Apples | |
3 | Joe | 5 | 4 | 3 |
<tbody>
</tbody>
I would like to be able to pull the sum of an array of columns if the two criteria (name and "apples" as the example) both match.
So sum if Table 1 A3 = "Joe" AND Table 1 B2 = "Apples". But I would like the sum range to be the whole of table 2, so that it would tell me that Joe has 8 apples total. When I put the sum range as B:D or similar, it gives me the #VALUE error.