Would you please help me to add numbers with certain specific/description. I just wanted to add all numbers which EAST numbers and West numbers separately as the desired result shown below
<tbody>
</tbody>
Thanks for your time and help.
Region | Amount |
North-West | 150 |
South-East | 200 |
South-West | 100 |
North-East | 150 |
North-West | 200 |
South-East | 150 |
South-West | 200 |
TOTAL | 1150 |
EAST | 500 - desired result |
WEST | 650 - desired result |
<tbody>
</tbody>
Thanks for your time and help.