Hi

One way, assuming your dates are in column A and values in column B

=SUMPRODUCT((TEXT($A$1:$A$1000,"yymm")="0802")*($B $1:$B$1000))

--

Regards
Roger Govier

"readystate" wrote in message
...
I have a worksheet with a Date Column. I want to include a formula that
will
add, for example, amounts for the month of February 2008. How would I set
that up? Thanks in advance.