counting problem

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

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





In article <A2311A7B-9201-4B1A-ACF8-04DD7DED529D@microsoft.com>,
philip <philip@discussions.microsoft.com> wrote:

> 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

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

"JE McGimpsey" wrote:

> 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
>
>
>
>
>
> In article <A2311A7B-9201-4B1A-ACF8-04DD7DED529D@microsoft.com>,
> philip <philip@discussions.microsoft.com> wrote:
>
> > 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
>

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

"JE McGimpsey" wrote:

> 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
>
>
>
>
>
> In article <A2311A7B-9201-4B1A-ACF8-04DD7DED529D@microsoft.com>,
> philip <philip@discussions.microsoft.com> wrote:
>
> > 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
>

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

"JE McGimpsey" wrote:

> 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
>
>
>
>
>
> In article <A2311A7B-9201-4B1A-ACF8-04DD7DED529D@microsoft.com>,
> philip <philip@discussions.microsoft.com> wrote:
>
> > 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
>

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





In article <A2311A7B-9201-4B1A-ACF8-04DD7DED529D@microsoft.com>,
philip <philip@discussions.microsoft.com> wrote:

> 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

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





In article <A2311A7B-9201-4B1A-ACF8-04DD7DED529D@microsoft.com>,
philip <philip@discussions.microsoft.com> wrote:

> 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