I have a worksheet with column N as "JoinDate," with dates listed as days of
the year, and column M as "MemberType:"

Column M Column N
MemberType JoinDate
Individual 2/14/2003
Individual 3/25/2003
Business 1/27/2003
Corporate 7/2/2003

I need help finding a formula to determine how many of each member type
joined during each month. I think it might be a SUMPRODUCT formula, but I
don't know how to specify an argument to find all dates between to other
dates (all days greater than or equal to Feb. 1 and less than or equal to
Feb. 28). Can anybody help me with this??

Assuming all the dates in Column N are "true" dates, enter the number of the
month you're looking for in P1 (1=Jan, 2=Feb ... etc.),and the member type
in O1, and try this formula:

=SUMPRODUCT((M2:M50=O1)*(MONTH(N2:N50)=P1))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"LoopKid" wrote in message
...
I have a worksheet with column N as "JoinDate," with dates listed as days
of
the year, and column M as "MemberType:"

Column M Column N
MemberType JoinDate
Individual 2/14/2003
Individual 3/25/2003
Business 1/27/2003
Corporate 7/2/2003

I need help finding a formula to determine how many of each member type
joined during each month. I think it might be a SUMPRODUCT formula, but I
don't know how to specify an argument to find all dates between to other
dates (all days greater than or equal to Feb. 1 and less than or equal to
Feb. 28). Can anybody help me with this??

That worked wonderfully, but I'm still missing one thing! I need to be able
to specify the year as well. Right now I'm getting all Individual members
who joined in January of any year, and I need to find how many joined in Jan
'02, Feb '02, Jan '03, etc.
This is closer than I've gotten in a week though! Thanks much for the input!

LK

"Ragdyer" wrote:

Assuming all the dates in Column N are "true" dates, enter the number of the
month you're looking for in P1 (1=Jan, 2=Feb ... etc.),and the member type
in O1, and try this formula:

=SUMPRODUCT((M2:M50=O1)*(MONTH(N2:N50)=P1))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"LoopKid" wrote in message
...
I have a worksheet with column N as "JoinDate," with dates listed as days
of
the year, and column M as "MemberType:"

Column M Column N
MemberType JoinDate
Individual 2/14/2003
Individual 3/25/2003
Business 1/27/2003
Corporate 7/2/2003

I need help finding a formula to determine how many of each member type
joined during each month. I think it might be a SUMPRODUCT formula, but I
don't know how to specify an argument to find all dates between to other
dates (all days greater than or equal to Feb. 1 and less than or equal to
Feb. 28). Can anybody help me with this??

Then in P1 enter a true date, and try this formula:

=SUMPRODUCT((M2:M50=O1)*(TEXT(N2:N50,"mm/yy")=TEXT(P1,"mm/yy")))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"LoopKid" wrote in message
...
That worked wonderfully, but I'm still missing one thing! I need to be
able
to specify the year as well. Right now I'm getting all Individual members
who joined in January of any year, and I need to find how many joined in
Jan
'02, Feb '02, Jan '03, etc.
This is closer than I've gotten in a week though! Thanks much for the
input!

LK

"Ragdyer" wrote:

Assuming all the dates in Column N are "true" dates, enter the number of
the
month you're looking for in P1 (1=Jan, 2=Feb ... etc.),and the member
type
in O1, and try this formula:

=SUMPRODUCT((M2:M50=O1)*(MONTH(N2:N50)=P1))
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"LoopKid" wrote in message
...
I have a worksheet with column N as "JoinDate," with dates listed as
days
of
the year, and column M as "MemberType:"

Column M Column N
MemberType JoinDate
Individual 2/14/2003
Individual 3/25/2003
Business 1/27/2003
Corporate 7/2/2003

I need help finding a formula to determine how many of each member
type
joined during each month. I think it might be a SUMPRODUCT formula,
but I
don't know how to specify an argument to find all dates between to
other
dates (all days greater than or equal to Feb. 1 and less than or equal
to
Feb. 28). Can anybody help me with this??