software

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,quot;mmmyyyyquot;)=quot;May2006quot;),Sheet2! B2:B2000)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;jjh64milesquot; gt; wrote in message
news
gt; I would like a simple formula which will give the totals for a month from
a
gt; (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
quot;Bob Phillipsquot; wrote:

gt; =SUMPRODUCT(--TEXT(Sheet2!A2:A2000,quot;mmmyyyyquot;)=quot;May2006quot;),Sheet2! B2:B2000)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;jjh64milesquot; gt; wrote in message
gt; news
gt; gt; I would like a simple formula which will give the totals for a month from
gt; a
gt; gt; (large)list in another worksheet .
gt;
gt;
gt;

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)

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