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(D2:D20,"yyyymm")<="200601"),--(TEXT(E2:E20,"yyyymm")="2
00601"),G2:G20)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"flow23" wrote in message
...
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