|
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 , philip 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 , philip 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 |
| All times are GMT +1. The time now is 07:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com