counting problem

[Guest]

I have post my question yesterday, seem there is no solution?? Is there
anybody can give me some alternative way to do it, will be greatly appreciate.

my problem is

Is there anyway to count the cell with bolded text (the text is bolded by
conditional format), the criteria is
1- $A1=" " > format text to bold
2- $A1>=1 > format text to color "blue" & "italic"
3- $A1="xx" > format text to color "red" & "italic"

will show:-

A B C D...
1 " " P1 P2 (bolded text by CF)
2 " " S1 (bolded text by CF)
3 1 x1
___________________________
count: 2 1


Please HELP

MANY THANKS
philip

 

[JE McGimpsey]

Since the text is bolded only if the cell contains a space character,
you could use

=SUMPRODUCT(--(A1:A3=" "),--(B1:B3<>"")) ==> 2

=SUMPRODUCT(--(A1:A3=" "),--(C1:C3<>"")) ==> 1

 

[Guest]

thanks JE Mcgimpsey

It works fine, thank very much, however, in order to make it more perfact,
how can I modify the formula not count the blank space in the cell.

thank again
philip