Deposits & Sales

Hi,

Firstly, thanks for all the great help so far!

Im doing a Cashflow Spreadsheet for the company and am currently using 2 sumif statments one minus the other to deal with date deposit paid against date sold.

as you can see from the enclosed sheet

April is -30,000 when it should be 30,000 and May is 315,000 when it should be 285,000 (which is minus the deposit)

What formula should i actually be using to resolve this?

any help is greatly appreciated!

Hi,

I am not sure to fully understand your difficulty ...
Attached is a proposal ...