SUMIF based on text in a 'date column'

[nythng]

I'm trying to add values in a different column based on the data in another column, I think I need to use a variation of =SUMIF but am not sure how to make it work.

For example:

A1:A20 are dates such as April 5, 2012 in one cell and April 6, 2012 and so on.

I'm trying to find out how to add the values in another column if the 'date column' has the text of 'April' and '2012'

Any suggestions?

Thanks

[Søren Larsen]

Try:

=SUMPRODUCT((LEFT($A$1:$A$20,FIND(" ",$A$1:$A$20)-1)=April)*1,(RIGHT($A$1:$A$20,4)*1=2012)*1,$B$1:$B$20)

Assuming the values you want to sum up are in $B$1:$B$20. Does it work?

[Cutter]

Or
=SUMIFS(B1:B20,A1:A20,"April*",A1:A20,"*2012")
or even
=SUMIF(A1:A20,"April*2012",B1:B20)

[Søren Larsen]

Or
=SUMIFS(B1:B20,A1:A20,"April*",A1:A20,"*2012")
or even
=SUMIF(A1:A20,"April*2012",B1:B20)

... go with Cutter's...