case number 1014140890

[drcarnine]

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..This is the year that I am trying to filter by

[#2]

@drcarnine 

[#3]

@drcarnine 

SUMPRODUCT would return your expected result, like this:

=SUMPRODUCT((YEAR(A3:A6)=F2)*B3:B6)

[#4]

@devyadav2008 

Thank you for your help. Is there a way I can also filter by C3:C6? I have been trying to use the sumifs function. See E3. I can get it to work for the month but not for the year. 

Thank you again

[#5]

@drcarnine 

As variant