Calc $ amts based on diff between 2 dates

[acs]

I am trying to set up a formula that will only add the $ amounts in one column(say column B) based on an ending date at the top of the spreadsheet and the beginning date in another column. I only want to add "deposits received" between the beginning of the month and today's date. Today's date is at the top of the page, whereas all the days of the month are in column A next to the column with the $ amounts.

 

[Brian from Maui]

I am trying to set up a formula that will only add the $ amounts in one column(say column B) based on an ending date at the top of the spreadsheet and the beginning date in another column. I only want to add "deposits received" between the beginning of the month and today's date. Today's date is at the top of the page, whereas all the days of the month are in column A next to the column with the $ amounts.

In what column is "deposits received" in?

 

[acs]

Column B. So every workday of the month(format is date=1/18) is in column A, the current date is in cell E3, and the deposit received $ amounts are in column B, next to the date received. Since we forecast our deposits, there is a $ amount next to every day of the month, but I only need the total actual deposits to date. Does this make more sense?

 

[Brian from Maui]

Column B. So every workday of the month(format is date=1/18) is in column A, the current date is in cell E3, and the deposit received $ amounts are in column B, next to the date received. Since we forecast our deposits, there is a $ amount next to every day of the month, but I only need the total actual deposits to date. Does this make more sense?

If I understand correctly,

=SUMIF(A1:A100,"<="&E3,B1:B100)

 

[acs]

Thank you, thank you. The formula is beautiful, however I am now encountering a $0 result due to a circular reference. I would love to send you the actual worksheet, however I am new to this website and have no idea how to attach one. My IT guy is a freak about unauthorized downloads, so I can't download the utility listed below. Can I just email the spreadsheet to you?[/img]

 

[Brian from Maui]

Thank you, thank you. The formula is beautiful, however I am now encountering a $0 result due to a circular reference. I would love to send you the actual worksheet, however I am new to this website and have no idea how to attach one. My IT guy is a freak about unauthorized downloads, so I can't download the utility listed below. Can I just email the spreadsheet to you?[/img]

In what cell did you enter the formula?

 

[acs]

I just figured out the circular reference - I had not changed the value of a cell that included the E3 date, so once that was updated, the formula worked perfectly. Thank you very much for your help.