How to use complex criteria in SUMIF()

I would like a simple formula which will give the totals for a month from a
(large)list in another worksheet .

=SUMPRODUCT(--TEXT(Sheet2!A2:A2000,"mmmyyyy")="May2006"),Sheet2!B2:B2000)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"jjh64miles" <[email protected]> wrote in message
news:[email protected]...
> I would like a simple formula which will give the totals for a month from
a
> (large)list in another worksheet .

Thanks I tried this - but dates all diferent days, i.e 01/12/05, 25/12/05,
15/12/05 etc(@500 per month) and list formatted for report so not by date.

jjh64miles



"Bob Phillips" wrote:

> =SUMPRODUCT(--TEXT(Sheet2!A2:A2000,"mmmyyyy")="May2006"),Sheet2!B2:B2000)
>
> --
> HTH
>
> Bob Phillips
>
> (remove xxx from email address if mailing direct)
>
> "jjh64miles" <[email protected]> wrote in message
> news:[email protected]...
> > I would like a simple formula which will give the totals for a month from
> a
> > (large)list in another worksheet .
>
>
>

But my example extracted the month from the date, so many per month, one or
none is irrelevant

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"jjh64miles" <[email protected]> wrote in message
news:[email protected]...
> Thanks I tried this - but dates all diferent days, i.e 01/12/05, 25/12/05,
> 15/12/05 etc(@500 per month) and list formatted for report so not by date.
>
> jjh64miles
>
>
>
> "Bob Phillips" wrote:
>
> >
=SUMPRODUCT(--TEXT(Sheet2!A2:A2000,"mmmyyyy")="May2006"),Sheet2!B2:B2000)
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove xxx from email address if mailing direct)
> >
> > "jjh64miles" <[email protected]> wrote in message
> > news:[email protected]...
> > > I would like a simple formula which will give the totals for a month
from
> > a
> > > (large)list in another worksheet .
> >
> >
> >