Need total of amounts between two dates. Dates and amts in two columns each.

I have a spreadsheet for all work billed and received - among other things. It's quite large.
Getting a total for what was billed each month is easy because the table is in date order of received/billed.
However, I get paid sometimes two months after billing and sometimes in split payments, so it's not a simple matter of just adding a column.

My received dates are in columns U and Z.
My amounts received are in columns T and Y.

Thanks!

Attach a Workbook
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

I want to delete the attachment and attach one differently.
Hope this works.
New spreadsheet for protonLeah.xlsx

And thank you for your assistance!
Callayne

Formula for AD2:

Please Login or Register  to view this content.

Dynamic Named Ranges:

Amt_Rcvd1, used rows of Column T

Please Login or Register  to view this content.

and similar for:
Amt_Rcvd2, used rows of zolumn Y
Paydate1, used rows of column U
Paydate2, used rows of column Z

I used the dynamic named ranges so that, as you add records (rows) you won't have to manually modify the formulas.

In this case, the SUMPRODUCT function is using your computer's memory to hold a list of the amount received if the month is 1 (January) and the date cell is not blank, then it just adds the list.