ExcelBanter - Creating a Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Creating a Formula (https://www.excelbanter.com/excel-programming/411548-creating-formula.html)

Charlotte

Creating a Formula

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?

Vergel Adriano

Creating a Formula

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?

Arnold[_2_]

Creating a Formula

"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?

All times are GMT +1. The time now is 02:43 PM.