Something like this:
=SUMIFS($C$8:$C$30,$A$8:$A$30,">"&DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),$A$8:$A$30,"<"&DATE(YEAR(TODAY()),MONTH(TODAY())+13,1))
But your months should be actual dates like 1-01-2018 and formated as dd-mmmm-yyyy
Something like this:
=SUMIFS($C$8:$C$30,$A$8:$A$30,">"&DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),$A$8:$A$30,"<"&DATE(YEAR(TODAY()),MONTH(TODAY())+13,1))
But your months should be actual dates like 1-01-2018 and formated as dd-mmmm-yyyy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks