formula to sum numbers based off of single or matching dates

Hello,

I am still attempting to find the reimbursement % for a very large data range. I am mostly there due to help I received from members of this forum! I noticed that some of my payments have multiple Dates that are the same and all attached to the same charge. As of now, they are all reflected as separate entities, which has skewed my reimbursement % numbers! Attached is a workbook that explains exactly what I need! Can anyone help?

Kaper,

definely a good start, however, it is not leaving the cell blank when the date in the current row is not equal to the date before it, but it's still equal to the date after it. Can that be fixed? attached is an example of what I would like to happen.

Did my last comment make sense?

Ahh! I figured it out. I just switched the two if statements, and now it works like a gem! Thank you very much for your help!