I have a spreadsheet that lists individual and renewal month:

A 1/1
A 2/1
A 1/1
B 1/1
B 2/1
B 1/1

I'm trying to count the total number of January renwals for "A" and January
renewals for "B" on a separate "Totals" page. The person I'm creating this
for has 2003 while I have 2007. I tried the "COUNTIFS" last time and it
doesn't produce a result for them. I'm banging my head against the wall.
Any help is appreciated.

Try something like this:

=SUMPRODUCT(--(A1:A10="A"),--(MONTH(B1:B10)=n))

Where n = month number: Jan = 1 thru Dec = 12

--
Biff
Microsoft Excel MVP


"Tamara" wrote in message
...
I have a spreadsheet that lists individual and renewal month:

A 1/1
A 2/1
A 1/1
B 1/1
B 2/1
B 1/1

I'm trying to count the total number of January renwals for "A" and
January
renewals for "B" on a separate "Totals" page. The person I'm creating
this
for has 2003 while I have 2007. I tried the "COUNTIFS" last time and it
doesn't produce a result for them. I'm banging my head against the wall.
Any help is appreciated.

I apologize that initially, I read the reply and just "pshawed" as I went a
totally different way. Now, I came back and did more research on SUMPRODUCT
and your answer is exactly what I've been looking for. Thank you so much and
I promise not to "pshaw" again! Thank you!!

"T. Valko" wrote:

Try something like this:

=SUMPRODUCT(--(A1:A10="A"),--(MONTH(B1:B10)=n))

Where n = month number: Jan = 1 thru Dec = 12

--
Biff
Microsoft Excel MVP


"Tamara" wrote in message
...
I have a spreadsheet that lists individual and renewal month:

A 1/1
A 2/1
A 1/1
B 1/1
B 2/1
B 1/1

I'm trying to count the total number of January renwals for "A" and
January
renewals for "B" on a separate "Totals" page. The person I'm creating
this
for has 2003 while I have 2007. I tried the "COUNTIFS" last time and it
doesn't produce a result for them. I'm banging my head against the wall.
Any help is appreciated.

I read the reply and just "pshawed"

Ah heck! Don't you trust me? <g

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Tamara" wrote in message
...
I apologize that initially, I read the reply and just "pshawed" as I went a
totally different way. Now, I came back and did more research on
SUMPRODUCT
and your answer is exactly what I've been looking for. Thank you so much
and
I promise not to "pshaw" again! Thank you!!

"T. Valko" wrote:

Try something like this:

=SUMPRODUCT(--(A1:A10="A"),--(MONTH(B1:B10)=n))

Where n = month number: Jan = 1 thru Dec = 12

--
Biff
Microsoft Excel MVP


"Tamara" wrote in message
...
I have a spreadsheet that lists individual and renewal month:

A 1/1
A 2/1
A 1/1
B 1/1
B 2/1
B 1/1

I'm trying to count the total number of January renwals for "A" and
January
renewals for "B" on a separate "Totals" page. The person I'm creating
this
for has 2003 while I have 2007. I tried the "COUNTIFS" last time and
it
doesn't produce a result for them. I'm banging my head against the
wall.
Any help is appreciated.