Hoping for some help with this:
=SUMIFS('2007-2014-15 stats'!D:H,'2007-2014-15 stats'!C:C,">=1/1/2015",'2007-2014-15 stats'!C:C,"<2/1/2015")
I tried entering as an array, and that isn't working. Columns have text headers so I am not sure SUMPRODUCT will work either and I'd like to not have to specify rows as the sheet continues to grow.
Trying to sum the values in columns D to H depending on the date value (by month) in column C.