Is this what you mean?

=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""))

In article ,
"Ray" wrote:

KL,

Thanks for your useful suggestion. Is it possible to apply to countif
function as well?

Thanks,

Ray