While organizing an event I have this simple table:

https://airtable.com/shrClDgt5JN17c7XX

People register on a certain date, and pay a certain amount

The same people pay what they are due a week or 2 later.

Now, here’s my thing: I want to know **per day** how much money is due. So if 2 people register on day 1, at the end of day 1 $30 is due

On day 2 $45 is added,

On **day 2** a total amount of #30+$45=**$75 is due**.

On day 7 people start paying.

What system could I use to visualize per day how much money is due? In a spreadsheet you can make use of sumif / sumifs but that is not possible in AirTable.