Creating a Formula

C

Charlotte

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

Vergel Adriano

Hi Charlotte,

Try this formula in B31:

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

Arnold

Charlotte said:
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?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum visible amounts 2
Excel spreadsheet to Word document 1
Formula for Data Validation 1
Formula needed to SUM and COUNT in specific way 1
Monthly percentage greater than a value 1
Search Target <= in Col. "B" to return Date in Col. "A" 1
Multiple Criteria for worksheet 3
Conditional formatting based on dates 1

Top