Count function

  • Thread starter Thread starter mkingsley
  • Start date Start date
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
 
Hi
try something like
=COUNTIF(A:A,"S")
and
=COUNTIF(A:A,"N")
if your values are stored in column A
 
Hi MKingsley!

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top