Counting non-blank cells with conditions

[Saylindara]

I have the following:

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

I would like to count the number of appointments that were sent for
referrals received in each month, e.g. for August it would be 2 and for
September 1.

Is that possible?

 

[Luke M]

something like this:

=SUMPRODUCT(--(MONTH(A2:A10)=8),--(ISNUMBER(B2:B10)))

Note that you can't callout entire columns (A:A) in SUMPRODUCT unless using
XL 2007. Feel free to change the "8" to a cell reference, if desired.

 

[Saylindara]

This worked perfectly thank you

something like this:

=SUMPRODUCT(--(MONTH(A2:A10)=8),--(ISNUMBER(B2:B10)))

Note that you can't callout entire columns (A:A) in SUMPRODUCT unless using
XL 2007. Feel free to change the "8" to a cell reference, if desired.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

 

[Saylindara]

Thisworked perfectly too, thank you