Creating a Criteria Series using SUMIFS

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

Leave a Reply

Your email address will not be published. Required fields are marked *