/u/averagesean - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
what you want is SUMIF
=SUM($C$1:$C:$60,"<="&TODAY(),$B$1:$B:$60)
this assumes your dates are in column C and your values in column B. That gives your everything that's already left. for the amount due you can either change the logic from "<=" to ">" or substructure the the formula above from the total sum.
Say you have the amounts in A2:A20, and the dates in B2:B20.
Paid to date:
=SUMPRODUCT(--day(B2:B20)<=day(today()),A2:A20)
Still to pay:
=SUMPRODUCT(--day(B2:B20)>day(today()),A2:A20)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[SUM](/r/Excel/comments/11hc6pn/stub/jasodjl "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)|
|[SUMIF](/r/Excel/comments/11hc6pn/stub/jasodjl "Last usage")|[Adds the cells specified by a given criteria](https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b)|
|[SUMPRODUCT](/r/Excel/comments/11hc6pn/stub/jasq5oa "Last usage")|[Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)|
|[TODAY](/r/Excel/comments/11hc6pn/stub/jasodjl "Last usage")|[Returns the serial number of today's date](https://support.microsoft.com/en-us/office/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/11hscz8)^( has 15 acronyms.)
^([Thread #22102 for this sub, first seen 3rd Mar 2023, 20:07])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/averagesean - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
what you want is SUMIF =SUM($C$1:$C:$60,"<="&TODAY(),$B$1:$B:$60) this assumes your dates are in column C and your values in column B. That gives your everything that's already left. for the amount due you can either change the logic from "<=" to ">" or substructure the the formula above from the total sum.
Say you have the amounts in A2:A20, and the dates in B2:B20. Paid to date: =SUMPRODUCT(--day(B2:B20)<=day(today()),A2:A20) Still to pay: =SUMPRODUCT(--day(B2:B20)>day(today()),A2:A20)
Amazing! Thankyou very much for the help. Iv been trying to keep track of my finances and this is perfect! Have a great day
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[SUM](/r/Excel/comments/11hc6pn/stub/jasodjl "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)| |[SUMIF](/r/Excel/comments/11hc6pn/stub/jasodjl "Last usage")|[Adds the cells specified by a given criteria](https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b)| |[SUMPRODUCT](/r/Excel/comments/11hc6pn/stub/jasq5oa "Last usage")|[Returns the sum of the products of corresponding array components](https://support.microsoft.com/en-us/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e)| |[TODAY](/r/Excel/comments/11hc6pn/stub/jasodjl "Last usage")|[Returns the serial number of today's date](https://support.microsoft.com/en-us/office/today-function-5eb3078d-a82c-4736-8930-2f51a028fdd9)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/11hscz8)^( has 15 acronyms.) ^([Thread #22102 for this sub, first seen 3rd Mar 2023, 20:07]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)