T. Valko wrote:
For the total in E11:

=E2+SUM(D3:D9)-SUM(C3:C9)

For the "total cleared" in E12:

=(F2="cleared")*E2+SUMIF(F3:F9,"cleared",D3:D9)-SUMIF(F3:F9,"cleared",C3:C9)

Biff


Hi Biff,

Worked perfectly... Thanks :)

Alex