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



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.



By: Courtney

Leave a Reply

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