Or maybe countif

=COUNTIF(A:A,"A")



--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"Bob Phillips" wrote in message
...
=SUMIF(A:A,"A")

etc.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I have to add up how many A's, S's, ST's and L's I have in a column how
do
I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A