Try the below to retrive the sum for Jan 08 (01/08)

=SUMPRODUCT(--(TEXT(B1:B10,"mm/yy")="01/08"),A1:A10)

If this post helps click Yes
---------------
Jacob Skaria


"soconfused" wrote:

I have a spreadsheet that looks something like this:

1 01/02/08
.2 01/06/08
.8 12/15/08
15 02/07/09
1.7 02/22/09
10 05/06/09

I want to add the first column (which is hours), but I need them added by
mm/yy.

Thanks,

--
DMM