Need to get sums based on codes in drop downs by week- Is pivot table right anser

[Cdavies]

I am using Excel2003.
I need two distinct sums:
I need to calculate out the loan amount of approved loans by week (weekending on Sunday).
For example for the week ending December 28th, 2013
$1,234,567,890 in total loans

I also need to have a list of sums of the loan amounts per code types of approved loans.
For the week ending December 28th, 2013
$123,456.00 in total loans for Code: LTV/TLTV > Guideline max
$987,654.00 in total loans for Code: FICO > 10 pts below Guideline min


I need to ignore any loan amounts and codes for any loans that have not yet had a approved date entered and also ignore all loan amounts for any loans that are denied.

I have tried doing this in many different ways with Pivot Tables and I am not getting the results I need.
I really appreciate any help anyone can give me. I am very new to doing these types of things in Excel.

[Cdavies]

My apologies, I don't know how this one got posted.

Mod please delete this post. The Second one has the attachment. My apologies.