Excel 2007 : Summing up values that match criteria.:use INDEX

As the title stated, I need to sum up values that meet a particular criteria. The issue, however, is that COUNTIF will not work in my case since the "criteria" is a cell reference.

Is it possible to use INDEX within a SUM function? I've tried the following:

=SUM(INDEX($C$2:$F$72,MATCH(H24,$F$2:$F$72,0),1))

And, of course, it stops after it finds the first match and doesn't continue down the column.

What I've been asked to do is ADD the total loan amounts that are paid on a daily, monthly, yearly basis.

Loan Amount || Interest Rate || Term(yrs) || Payments Made(period type)

11,000 8.00 4 Monthly

There are 400 rows of info similar to the above. If the payment period type is Monthly, I need to sum up all cells in the Loan Amount column that are monthly.

Edit: Wrong Forum?! Sorry if so.