Hi, my problem is: I have a table with values in a sheet called "Hist", imagine this:
<tbody>
</tbody>
And in another sheet caled "Classification" I have in A2 "Michael Hepburn", and I'd like to have in B2 the sum of all Michael Hepburn values in "Hist" when the cell next to it is not blank. In this case, the result of that sum would be 50 + 10 = 60.
Michael Hepburn | 90 | |
Michael Hepburn | Team A | 50 |
Michael Hepburn | Team A | 10 |
Andrey Zeits | Team B | 40 |
<tbody>
</tbody>
And in another sheet caled "Classification" I have in A2 "Michael Hepburn", and I'd like to have in B2 the sum of all Michael Hepburn values in "Hist" when the cell next to it is not blank. In this case, the result of that sum would be 50 + 10 = 60.