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 .

How to use complex criteria in SUMIF()
 

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

How to use complex criteria in SUMIF()
 

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" wrote in message
...
I would like a simple formula which will give the totals for a month from
a
(large)list in another worksheet .

How to use complex criteria in SUMIF()
 

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" wrote in message
...
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" wrote in message
...
I would like a simple formula which will give the totals for a month
from
a
(large)list in another worksheet .