COUNTIFS and SUMPRODUCT help

I am trying to figure out how to make a cell diplay a sum of other cells in the worksheet IF they meet 2 criteria found in other columns. So for example, Column A displays loan amounts, Column B shows interest rates, Column C shows terms. I want a seperate cell in the worksheet to search columns B and C and if both criteria are met then sum the amounts from column A.
Loan Amounts Rate Term
155,000 3.25 360
125,600 4.0 360
265,000 3.25 120
189,500 3.25 360

I want a cell somewhere else in the worksheet that would show a result of 344,500 (amounts from column A that meet both criteria of 3.25 AND 360, summed)
Any help would be appreciated!

Hi Stacy

carrob's formula is the one. Might i also suggest that you use a cell (possibly even with a drop down box for data validation) that you can enter the variables into. This makes the sheet more flexible.

So using carrob's formula, instead of the sections "=3.25" and "=360", use a cell reference of say D1 and D2.

Then you can enter into D1 any rate that you want to search for, and in D2 have any term.
It will then give you a sum of all of the loans that meet the criteria.

the data validation will help if you only have specific terms or rates, so you can pick them from a drop down box.

Hope this helps make your sheet more valuable.

You're testing the range C2:C47 for 2 different conditions at the same time.

C2:C47 = 120
C2:C47 = 180

The cells can not = 120 and 180 at the same time so the result will always be 0.

Like this...

=SUM(SUMIFS($A$2:$A$47,$B$2:$B$47,4%,$C$2:$C$47,{120,180}))