05-12-2018, 04:34 PM
|
#4
|
@TimeformUSfigs
Join Date: Jan 2002
Location: Moore, OK
Posts: 46,826
|
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* "))
|
Can you give an example of what you are trying to accomplish with actual data?
|
|
|