Try this...

=SUMPRODUCT(--(MONTH(C1:C{x})=D1), (U1:U{x}))
..
All you need to do is alter cell D1 to be the number value of thwe month in
question May = 5, December = 12 etc...) and replace the {x} with a number
equal to the number of rows you have.

HTH.

"Annette" wrote:

> I can't figure out how to read a date in a formula. In my column I have the
> format set as mm/dd/yy, but the formula is looking at MMM and it is not
> converting.
>
> I want to add sums of money based on month, not mm/dd/yy and I think that is
> where I'm faultering.
>
> Here are details:
>
> cell d1 = May
> col c = dates (ie, 05/03/06)
> col u = amounts
>
> I want to add all the amounts that fell during the month of
> May. How do I write this? THanks!
>
>
>