How to use complex criteria in SUMIF()

J

jjh64miles

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

Bob Phillips

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
J

jjh64miles

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
 
B

Bob Phillips

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)
 
Top