drcarnineCopper ContributorDec 04, 2020case number 1014140890 I have a test spreadsheet that I am trying to sum a column of values if the corresponding date is of a certain year A3:A6 is a column of dates B3:B6 is column of values I want to sum F2 is 2019..T...Show Moreformula.xlsx11 KB
TwifooSilver ContributorDec 04, 2020drcarnine SUMPRODUCT would return your expected result, like this:=SUMPRODUCT((YEAR(A3:A6)=F2)*B3:B6)
