Hi All
Newbie on here so any help would be appreciated.
Column A has dates up to the end of the year.
Column B has a forecast up to the end of the year
What i am trying to do is find a formula that adds up the next 12 days in column B based on the current date automatically.
I have tried Sumif but can not get it to work. I have added the worksheet which hopefully makes it easier to understand.
Please help
This is what i have so far however it adds up the whole column form todays date. Only need next 12:
=SUMIF($A$2:$A$143,">"&TODAY(),B2:B143)
Bookmarks