Dec 04 2020 09:33 PM
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
Dec 04 2020 11:09 PM
SUMPRODUCT would return your expected result, like this:
=SUMPRODUCT((YEAR(A3:A6)=F2)*B3:B6)
Dec 05 2020 01:35 AM
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