=if(countif(A1:A10,"A")-Sumproduct(--(A1:A10="A"),--(B1:B10)="")=0,"All
blank",if(Sumproduct(--(A1:A10="A"),--(B1:B10)="")0,"some blank","none
blank"))

--
Regards,
Tom Ogilvy

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

I don't know how to use countif to check it.
I need to check which rows in the group-column = "A" (for example)
and then if all the rows in the value-column are empty.

How can I do this ?

Case 1 (Some group A rows are not empty):

group,value
A,0
A,0
B,3
A,0
B,8
C,5
A
.
.
.


Case 2 (All group A rows are empty):

group,value
A
A
B,3
A
B,8
C,5
A
.
.
.


Thank you
Gil D.