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

have a look in the help index for COUNTIF

--
Don Guillett
SalesAid Software
[email protected]
"fomula problems" <[email protected]> wrote in
message news:[email protected]...
>I would like to show the number of 1's, M's, A's and blank cells in a
>column,
> can anyone help.
> Alan

="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" <[email protected]> wrote in
message news:[email protected]...
> I would like to show the number of 1's, M's, A's and blank cells in a
column,
> can anyone help.
> Alan