Spreadsheet sum with condition of value of a column

3 down vote favorite

I want a spreadsheet function that will produce a sum of all values in column B for when column A is equal to 'X' and when it is equal to 'Y' A B X 10 Y 3 X 7 X 22 Y 4 Y 9 The output should look like the following (where 39 & 16 are the results of the formulas): X 39 -> 10 + 7 + 22 Y 16 -> 3 + 4 + 9 Symphony , Excel as well? X 10 Y 3 X 7 X 22 Y 4 Y 9 X "=SUMIF(A1:A6;A8;B1:B6)" Y "=SUMIF(A1:A6;A9;B1:B6)"