Summing rows values while a specific column answers a specific condition.

Its much smaller than the sheet I work with but for this example I want to scan column 1 representative and if the value in a cell form A2:A6="D" I want to sum its rows.

in this case I expect the answer 3+1+8+1=13.

Tried the sumif but it works for 1 column at a time and not scanning multiplied arrays.

Tried sumproduct and still couldnt get the cell to show the total amount.

since in my actual worksheet there are 37X57 array, going manually and put formula in each specific row is less ideal soo I am looking for a specific command to solve it and calculate along the data that changes on the sheet.