See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--

HTH

Bob Phillips

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

"Bob Newman" <bobnewman@cox.net> wrote in message
news:vy_kg.112403$Ce1.94109@dukeread01...
> Thanks. One question though. What are the 2 dashes before the
> (MONTH(A2:A2000)?
>
> Bob
>
> "Bob Phillips" <bob.NGs@xxxx.om> wrote in message
> news:O0KjPSlkGHA.4512@TK2MSFTNGP04.phx.gbl...
> > =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
> >>
> >>
> >
> >
>
>