Count

  • Thread starter Thread starter Matt Kubinski
  • Start date Start date
M

Matt Kubinski

I have a schedule where I put in initials in it. Within a two week period,
how do I have excell count how many times that inital appears?
a b
1 bnm abc
2 dsa bnm
3 wlo dsa

with the above example it would count the number of times it see certain
initals. ie BNM 2
DSA 2 ABC 1 WLO 1

Thanks
 
Hi Matt!

Use:
=COUNTIF($A$1:$B$3,"bnm")

Or if you put the initials you want to count in a cell:

=COUNTIF(A1:B3,D1)


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