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" <(E-Mail Removed)> wrote in message
news:7F1CF107-2677-456F-AAF2-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:7F1CF107-2677-456F-AAF2-(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message
news:FAFDD165-474E-4168-8167-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:7F1CF107-2677-456F-AAF2-(E-Mail Removed)...
>> >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.
>> >
>>
>>
>>