I was wondering if there was a formula that I could use to sum a data file using the below columns as the lookup, I would also like to use another criteria in addition to this.
I.e If any of the numbers in column A appears in raw data file, sum the respective number in another column
<tbody>
</tbody>
Thanks in advance
I.e If any of the numbers in column A appears in raw data file, sum the respective number in another column
A | B | C | D | E |
56 | 16 | 20 | 98 | 87 |
4 | 2 | 7 | 9 | 65 |
695 | 546 | 110 | 848 | 464 |
854 | 205 | 331 | 550 | |
484 | ||||
<tbody>
</tbody>
Thanks in advance