Counting dates with conditions
 

I have been counting the number of appointments that were sent for
referrals received in each month, e.g. for the sample below it would be 2
August and 1 for September. I have successfully been using this formula:

=SUMPRODUCT(--(MONTH(A2:A10)=cell reference with
month-year),--(ISNUMBER(B2:B10)))

This has been so successful I want to continue it for next year. Is there
some way I can include the year in the formula.



Referral received Appointment sent
3/8/09 31/8/09
4/8/09 2/9/09
5/8/09
2/9/09
3/9/09 4/9/09
5/9/09

Counting dates with conditions
 

Try it this way:
=SUMPRODUCT(--(TEXT(A2:A10,"yyyymm")=TEXT(cell
reference,"yyyymm"),--(ISNUMBER(B2:B10)))

Regards,
Fred


"Saylindara" wrote in message
...
I have been counting the number of appointments that were sent for
referrals received in each month, e.g. for the sample below it would be 2
August and 1 for September. I have successfully been using this formula:

=SUMPRODUCT(--(MONTH(A2:A10)=cell reference with
month-year),--(ISNUMBER(B2:B10)))

This has been so successful I want to continue it for next year. Is there
some way I can include the year in the formula.



Referral received Appointment sent
3/8/09 31/8/09
4/8/09 2/9/09
5/8/09
2/9/09
3/9/09 4/9/09
5/9/09

Counting dates with conditions
 

Thanks for your help. Sorry for the delay in replying but I've had the
dreaded lurgy for the last few days.

"Fred Smith" wrote:

Try it this way:
=SUMPRODUCT(--(TEXT(A2:A10,"yyyymm")=TEXT(cell
reference,"yyyymm"),--(ISNUMBER(B2:B10)))

Regards,
Fred


"Saylindara" wrote in message
...
I have been counting the number of appointments that were sent for
referrals received in each month, e.g. for the sample below it would be 2
August and 1 for September. I have successfully been using this formula:

=SUMPRODUCT(--(MONTH(A2:A10)=cell reference with
month-year),--(ISNUMBER(B2:B10)))

This has been so successful I want to continue it for next year. Is there
some way I can include the year in the formula.



Referral received Appointment sent
3/8/09 31/8/09
4/8/09 2/9/09
5/8/09
2/9/09
3/9/09 4/9/09
5/9/09



.