Paul,
Thanks for the help. Your formula worked but please help me to understand
why?

Keyco


"PCLIVE" wrote:

Use SUMPRODUCT:

=SUMPRODUCT(--($D$7:$D$43=$B49),--($U$7:$U$43<2))

Does that help?
Regards,
Paul

--

"Keyco" wrote in message
...
I am trying to use the countif function and need to count a person if they
are in a certain state and started before a certain month. I have the
right
range and criteria for each of the two conditions but don't know how to
use
them together. I tried =COUNTIF($D$7:$D$43,$B49,$U$7:$U$43,"<2"), but
this
is not a valid formula. Any thoughts?