Match Dates and Total Amounts between tabs

[Lady Owl]

I need to determine how much money we have mailed out on any given day as well as how much has not yet cleared the bank. I have a spreadsheet with two tabs - Tab A has multiple columns, including Amount (Column D), Date Mailed (Column E), and Date Cleared (Column F). On Tab B, Column A is a list of dates (one cell for each day of the year); Column B is the total amount mailed on that day; Column C is the total amount outstanding as of that date. I would like to create a formula (or formulas) that would populate Columns B and C on Tab B, based on the data entered on Tab A. Thank you!

[JohnTopley]

Please see yellow banner at top of the page on how to post a sample workbook which should include example(s) of expected output.

[Lady Owl]

Please see attached sample file for the following question:
I need to determine how much money we have mailed out on any given day as well as how much has not yet cleared the bank. I have a spreadsheet with two tabs - Tab A has multiple columns, including Amount (Column D), Date Mailed (Column E), and Date Cleared (Column F). On Tab B, Column A is a list of dates (one cell for each day of the year); Column B is the total amount mailed on that day; Column C is the total amount outstanding as of that date. I would like to create a formula (or formulas) that would populate Columns B and C on Tab B, based on the data entered on Tab A. Thank you!

[JohnTopley]

Try

in B3

Please Login or Register  to view this content.

in C3

Please Login or Register  to view this content.

[Lady Owl]

The formula for Column B worked perfectly - THANK YOU!

The formula for Column C isn't calculating a new total - it just displays the initial entry. (See attached updated file.)

[Gregb11]

You left out the reference to the Tab in John's formula. Copy just as John has it written:

=$C2-SUMIFS('Tab A'!D:D,'Tab A'!F:F,$A3)