Count function

M

mkingsley

I have a backorder report that comes each morning, that has a colum
which contains an alpha character, S (means stocking item) and N (mean
non-stocking), I was wondering if I count use the COUNT function t
give me the total number of stocking backorders and the non-stocks a
well. It would look like this when I am done. I just need a quick an
dirty count. The count function would count the number of occurances o
each alpha character. If so, what would the formula look like?

S 25
N 3
 
F

Frank Kabel

Hi
try something like
=COUNTIF(A:A,"S")
and
=COUNTIF(A:A,"N")
if your values are stored in column A
 
N

Norman Harker

Hi MKingsley!

Try:
=COUNTIF(A1:A200,"N*")
=COUNTIF(A1:A200,"S*")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top