Hi

WIth your data in column A:B you can use this formula:

=SUMPRODUCT(--(A2:A11="LoMt-1"),--(B2:B11=""))

Regards,
Per


On 10 Aug., 02:13, Rambo wrote:
Hi, I have the following condition:

Zone * * * * * * *Score
LoMt-1 * * * * * * 100
LoMt-1 * * * * * * *
LoMt-1 * * * * * * *0
LoMt-1 * * * * * * *50
LoMt-1 * * * * * * 100
LoMt-2 * * * * * * *0
LoMt-2 * * * * * * * * * * *
LoMt-2 * * * * * * *50
LoMt-2 * * * * * * 100
LoMt-2

I try to use "Dcounta" function to count a specific zone without any score. *
It gives me "VALUE!". *Why? The correct answer should be only 1 blank in
LoMt-1 and 2 blank in LoMt-2 based on the above condition.

Can you please help with the function either "dcounta" or "sumproduct"?
Thanks in advance.