How to Auto Add Columns by current date.

[68rs327]

I am trying to make a spreadsheet I have on cost to auto add by current date. Some of the cost savings are set for future dates, some are current date and some are past dates. How do you auto add by current date when you open the excel file?

[/IMG]

 

[Joe4]

Use SUMIF, like this:

=SUMIF(A:A,"<=" & G1,B:B)

or this:

=SUMIF(A:A,"<=" & TODAY(),B:B)

 

[68rs327]

I sent you a message.
Thanks,

 

[Joe4]

I sent you a message.

Please keep the question to this public thread, as per rule 4 here: https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html