Switching Date into full year not working?

[Ronderbecke]

Hey There,

Currently I am using this formula:

=SUMPRODUCT(IF(MOD(ROW(C12:C)-ROW(C12),12)=0,IF(ISNUMBER(C12:C),IF(C12:C-DAY(C12:C)+1=DATE(2017,8,1),C4:C))))

Which works great; however, when I try to get all the data from the whole year and switch to:

=SUMPRODUCT(IF(MOD(ROW(C12:C)-ROW(C12),12)=0,IF(ISNUMBER(C12:C),IF(C12:C-DAY(C12:C)+1=Year(2017),C4:C))))

It doesn't work at all? Am I doing something wrong here?

 

[sheetspread]

C12:C isn't a valid reference (at least in the Excel version I use). As for the rest:

=SUMPRODUCT(IF(MOD(ROW(C12:C)-ROW(C12),12)=0,IF(ISNUMBER(C12:C),IF(year(C12:C-DAY(C12:C)+1)=2017,C4:C))))

may be one way to expand for the year.