Creating a Formula

  • Thread starter Thread starter Charlotte
  • Start date Start date
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?
 
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
Select / Copy / Paste 6
3 results possible on every day. add up the number of each on each day. 2
Search Target <= in Col. "B" to return Date in Col. "A" 1
Formula for Data Validation 1
Monthly percentage greater than a value 1
Data in columns 1

Back
Top