Excel Data Frequency Sum Help

*UPDATED* Hi there, I wonder if anyone is savvy enough to help me as I am struggling with the correct sum to use in excel.   I have certain payments, and frequencies between certain dates that I ne...