You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Suzanne" wrote in message
...
Thank you very much T. Valko, i wasn't aware of the column range
limitation.
Appreciate it. Enjoy the day.

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A1:A10="Sched"),--(ISNUMBER(B1:B10)))

Note: you can't use entire columns as range references (unless you're
using
Excel 2007).

--
Biff
Microsoft Excel MVP


"Suzanne" wrote in message
...
Hello. I want to count the dates in column B where the corresponding
value
in column A is 'Sched'. Expecting the answer to be: 2 for the example
below.
I've tried to use and array (which i rarely use), i've also looked into
SUMPRODUCT (which i've never used). I haven't had any luck with
either.
Can
anyone help please?

A B
1 Sched 2/15/2007
2 2/19/2007
3 Sched 3/1/2007
4 Sched
5