Sorry, misread your question

=Sumproduct(--(A1:A10="A"),--(B1:B10)="")

will give you the number of blanks.
--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
Use countif to check.

--
Regards,
Tom Ogilvy


"Gil D." wrote in message
ups.com...
Hello,

My problem is that I don't know weather the sumif returns zero because
there is no value is the choosen lines or the total sum of choosen
lines values is zero.

For example:

Case 1:
group value
A 0
A

sumif which sums values for group A lines will return: 0

Case 2:
group value
A
A

sumif which sum values for group A lines will return: 0

How can I check wheather all choosen lines are empty ?

Thank you for yor help
Gil D.