I'm attempting to use the criteria from two columns to SUM a third column, however one of the criteria columns is date (M/D/YYYY) and I'm only attempting to use the Year as criteria.
Tried multiple formulas and none work.
Think I'm close here, however it gives a weird Date result, rather than a SUM
=SUM(SUMIFS(B1:B210,D1
210,"ABHZ",C1:C210,"*1970* "))