SUMIF with Date

[OMGWATDO]

I have dates like:

21.05.2014
21.05.2014
21.05.2015

A1:A3


and the coresponding numbers next to it

100
60
200

B1:B3


I need a SUM of the number if and only if the year is 2014, or 2015, etc. How do I do that?

[Ron Coderre]

If those are actual dates (formatted to look that way), then:

Please Login or Register  to view this content.

Otherwise, if Col_A contains numeric text

Please Login or Register  to view this content.

Is that something you can work with?

[nigelbloomy]

If your dates are text then you can use this:

Please Login or Register  to view this content.

If they are dates and just formatted like that, then you will need to use this:

Please Login or Register  to view this content.

[OMGWATDO]

Almost,

the sum product doesn't work, because I need to seperate the numbers.

I have a column for 2014, 2015, 2016, etc.

In column 2014 only the sum of the numbers from 2014 is put in, and so on.

[newdoverman]

Maybe something like this would be of interest:

Please Login or Register  to view this content.

	A	B	C	D	E
1	21.05.2014	100		2014	160
2	21.05.2014	60		2015	200
3	21.05.2015	200

[AlKey]

Or this

enter formula in C2 and pull it to the right

=SUM(INDEX((--RIGHT($A$2:$A$4,4)=C$1)*($B$2:$B$4),0))

Row\Col	A	B	C	D
1	Date	Value	2014	2015
2	21.05.2014	100	160	200
3	21.05.2014	60
4	21.05.2015	200