software

Colum D has start date and colum E has end date colum G has unique records
(1,0)

what I want is a list from this database saying how many members were active
in in a particular month
Jan 06 -- XX
Feb06- xxx
and so on
=SUMPRODUCT(--(TEXT(D220,quot;yyyymmquot;)lt;=quot;200601quot;),--(TEXT(E2:E20,quot;yyyymmquot;)gt;=quot;2
00601quot;),G2:G20)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;flow23quot; gt; wrote in message
...
gt; Colum D has start date and colum E has end date colum G has unique
records
gt; (1,0)
gt;
gt; what I want is a list from this database saying how many members were
active
gt; in in a particular month
gt; Jan 06 -- XX
gt; Feb06- xxx
gt; and so on
gt;
gt;