Q2 = DSUM(A3:I26, C3, A28:I29)
Total amount of mortgage loans issued
Total amount of mortgage loans issued by the Kendall branch
Total monthly payments
Total monthly payments for loans issued by the Kendall branch
Total amount of loans issued by the Kendall branch
Total monthly payments for mortgage loans issued by the Kendall branch
What information will be obtained from the formula:
=DSUM(A3:I26, C3, A28:I29)
B
C
D
E
-
1 Analysis of Consumer Loans 2 Loan Loan Interest Monthly 3 Loan ID Branch Amount Type Rate Term Start Date End Date Payment 4 L0007 North Miami $10,000 A 4.00% 7/28/20047/28/2007 5295.24 5 L0009 Opa Locka $25,000 A 8.50% 3 8/4/20048/4/2007S789.19 6 L0011 Kendall $56,000 A %009 8/6/20048/6/2007 S1,703.63 7 L0013 Kendall $35,000 A 7.50% 3 8/14/20048/14/2007S1,088.72 8 L0021 Opa Locka $41,000 A 8.40% 3 9/21/20049/21/2007S1,292.37 9 L0006 North Miami $36,000 A 5.70% 4 7/26/20047/25/2008 S817.17 10 L0020 Kendall $25,000 A 7.00% 4 9/18/20049/17/2008 99869 11 L0003 North Miami $475,000 M 5.40% 15 7/18/20047/15/2019 53,855.99 12 L0012 Kendall $50,000 M 7.00% 15 8/13/20048/10/2019 S449.41 13 L0014 Kendall $150,000 M 6.00% 15 8/24/20048/21/2019S1,265.79 14 L0016 Opa Locka $200,000 M 6.50% 15 9/4/2004 9/1/201951,742.21 15 L0019 Kendall $275,000 M 7.70% 15 9/11/20049/8/2019 S2,580.64 16 L0022 Kendall $75,000 6.00% 15 9/25/20049/22/2019 $632.89 17 L0001 Opa Locka $525,000 M 5.00% 30 7/11/20047/4/2034 S281831 18 L0005 Opa Locka $250,000 M 7.30% 30 7/23/20047/16/2034 S1,713.93 19 L0015 Kendall $75,000 M 5.50% 30 8/25/20048/18/2034 5425.84 20 L0018 North Miami $350,000 M 6.70% 30 9/6/20048/30/203452,258.47 21 L0023 Kendall $15,000 P 5.00% 10/3/200410/3/2007 $449.56 22 L0002 Kendall $10,500 P 6.00% 7/15/20047/14/2009 S202.99 23 L0004 Kendall $35,000 P %009 7/18/20047/17/2009 $660.49 24 L0010 North Miami $20,000 P %00 5 8/4/20048/3/20095406.53 25 L0017 Kendall $15,000 P 6.50% 5 9/4/20049/3/20095293.49 26 L0008 North Miami $12,000 8.00% 10 8/3/20048/1/2014S145.59 27 Loan Loan Interest Monthly 28 Loan ID Branch Amount Type Rate Term Start Date End Date Payment 29 Kendall M 30