I am trying to create a series of one of my criteria to copy across the rows of my spreadsheet. The criteria is a date range. I am currently manually modifying the formula to change the date for each column.
This is the formula in C13
=SUMIFS(Spend!$D:$D,Spend!$E:$E,”Janitoral”,Spend!$A:$A,“>=2/1/2018”,Spend!$A:$A,“<=2/28/2018”)
The highlighted part, I change in each column to make the range summed one month. Is there a way I can make this a series, so I can just drag it across the row?
Here is a screenshot of my spreadsheet.
http://tinypic.com/r/flkads/9
By: Courtney