G Guest Jun 25, 2006 #1 I would like to show the number of 1's, M's, A's and blank cells in a column, can anyone help. Alan
C CLR Jun 25, 2006 #3 ="1's="&COUNTIF(A:A,1)&CHAR(10)&"M's="&COUNTIF(A:A,"m")&CHAR(10)&"A's="&COUN TIF(A:A,"a") Format for Wrap-Text Vaya con Dios, Chuck, CABGx3
="1's="&COUNTIF(A:A,1)&CHAR(10)&"M's="&COUNTIF(A:A,"m")&CHAR(10)&"A's="&COUN TIF(A:A,"a") Format for Wrap-Text Vaya con Dios, Chuck, CABGx3
