counting
 

I would like to show the number of 1's, M's, A's and blank cells in a column,
can anyone help.
Alan

counting
 

have a look in the help index for COUNTIF

--
Don Guillett
SalesAid Software

"fomula problems" wrote in
message ...
I would like to show the number of 1's, M's, A's and blank cells in a
column,
can anyone help.
Alan

counting
 

="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


"fomula problems" wrote in
message ...
I would like to show the number of 1's, M's, A's and blank cells in a
column,
can anyone help.
Alan