Countif for 2003

[Tamara]

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.

 

[T. Valko]

Try something like this:

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

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

 

[Tamara]

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]

I read the reply and just "pshawed"

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

You're welcome. Thanks for the feedback!