Quote:
Originally Posted by wilderness
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* "))
|
Will the year function help? I am not clear on what you are trying to do but it seems like if you add a column, convert the date with the year function into the new column, you should be able do to do what you are trying to do.
https://exceljet.net/excel-functions...-year-function