Summing weekly balances

[meamuka]

Hi guys!

I have to do a weekly cash report:

1	2	3	4
A	Balance as of	drop-down date (e.g. 1 sep 15)	1xx0x (formula here. NOTE: end of the day balance)
B	Cash in		1xx1 (from day 2 and so on)
C	Cash out		-1xx2 (from day 2 and so on)
D	Balance as of	drop-down date (e.g. 10 sep 15)	1xx0 (that's the simple part: A+B-C)

<tbody>
</tbody>

I want to change only the dates and the formula would give me the final balances.

The database is as follows:

Data	Cash In	Cash Out	Balance
1 sep 15	50		50
1 sep 15		40	10
5 sep 15	30		40
10 sep 15	20		20

<tbody>
</tbody>

Maybe the formula would include something with a SUMPRODUCT or another formula. If anyone has any idea please share.

Thanks in advance!

 

[meamuka]

I'm doing it with a SUMPRODUCT but it's considering the blank cells as zeros and thus it will show a 0 result.

 

[meamuka]

Anyone?