G Guest May 17, 2006 #1 I would like a simple formula which will give the totals for a month from a (large)list in another worksheet .
I would like a simple formula which will give the totals for a month from a (large)list in another worksheet .
B Bob Phillips May 17, 2006 #2 =SUMPRODUCT(--TEXT(Sheet2!A2:A2000,"mmmyyyy")="May2006"),Sheet2!B2:B2000) -- HTH Bob Phillips (remove xxx from email address if mailing direct)
=SUMPRODUCT(--TEXT(Sheet2!A2:A2000,"mmmyyyy")="May2006"),Sheet2!B2:B2000) -- HTH Bob Phillips (remove xxx from email address if mailing direct)
G Guest May 17, 2006 #3 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
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 May 18, 2006 #4 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)
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)
