Total sum dependant on date

[kma3232]

I'm not very good at Excel and not even sure if this is possible!

I've been putting a spreadsheet together for all my bills. I wanted to see how much I need in my bank account for all the bills from today's date. Something like this...

Screenshot 2020-02-29 at 17.00.18.png

Is this possible?! Thanks!

[jeffreybrown]

You could try this

Data Range

	A	B	C	D
1	Bill	Date
2	10	02
3	5	05
4	30	05	06	40
5	20	10
6	20	15

B2:B6 is an actually date with it showing day only. Same with C4

[kma3232]

Thanks Jeff

Is there any way I can automate the figure in D4?

So as C4 is more than B5 & B6, then add A5 & A6. Does that make any sense?!

[jeffreybrown]

Sorry about that, I left off the formula

D4 =SUMIF(B:B,">="&C4,A:A)

[kma3232]

Thank you, thank you, thank you!!

[jeffreybrown]

You are very welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Note: It could be a big help in the future if you updated your profile to indicate the Excel version you are using.