Forum Discussion
Solved
Get Monthly Numbers from Weekly Reports with Two Date Columns
Hello all, We were initially going to use Power BI for a Dashboard project we are working on, but thanks to their latest update, we don't think it'll be a viable option in time. So in the meanti...
Just solved it myself! I also found a few items in my formula that could've been cleaned up a bit. Here is what I got should you have trouble in the future as well:
=SUMIFS(K$3:K$2001,$G$3:$G$2001,">="&$G$1,$I$3:$I$2001,"<="&$I$1)=SUMIFS( [range to be summed], [range of start dates],">="&[start date desired], [range of end dates],"<="&[end date desired]).
Just solved it myself! I also found a few items in my formula that could've been cleaned up a bit. Here is what I got should you have trouble in the future as well:
=SUMIFS(K$3:K$2001,$G$3:$G$2001,">="&$G$1,$I$3:$I$2001,"<="&$I$1)
=SUMIFS( [range to be summed], [range of start dates],">="&[start date desired], [range of end dates],"<="&[end date desired]).