Numbers (ipad) if value for a row in column 1=A, then add same row of column 2's value to a total
So I have something like this
| Column1 | Column2 |
|---|---|
| A | 3 |
| B | 2 |
| A | 4 |
| C | 1 |
| A | 6 |
| A | 2 |
Is there a way to add up the corresponding rows of all column2 that have a column1 value of A?
so in this situation the answer is 3+4+6+2=15
Thanks!