Hi Charlotte,

Try this formula in B31:

=B26+B27-SUMIF(D7:D19, ""&TODAY(), B7:B19)

--
Hope that helps.

Vergel Adriano


"Charlotte" wrote:

I need help in creating a formula in a banking spreadsheet.
Col B 7 thru B 19 contains $ amounts.
I want cell B31 (Cash available) to reflect B26+B27 minus any amount in Col
B that has a date in Col D that is greater than the current date (today's
date).

Can anyone help me?