=SUMPRODUCT(--(MONTH(A2:A200)=1),B2:B200)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Bob Newman" <bobnewman@cox.net> wrote in message
news:T5_kg.112400$Ce1.43449@dukeread01...
> Excel 2003
>
> I have a sheet with col. A being a list of dates and the other columns
being
> various figures. I know how to use the sumif function to give me totals
for
> a particular date in col A. How would I do something similar except
giving
> me sums for all figures within a particular month?
>
>
>
> Thanks in advance... Bob
>
>