Counting non-blank cells with conditions
This worked perfectly thank you
"Luke M" wrote:
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" wrote:
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?
|