case number 1014140890

Question

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

devyadav2008 · Answer

drcarnine&nbsp;&nbsp;&nbsp;

twifoo · Answer

drcarnine&nbsp;SUMPRODUCT would return your expected result, like this:=SUMPRODUCT((YEAR(A3:A6)=F2)*B3:B6)

drcarnine · Answer

devyadav2008&nbsp;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.&nbsp;Thank you again

sergeibaklan · Answer

drcarnine&nbsp;
As variant

Forum Discussion

case number 1014140890

4 Replies