Count

[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

 

[Norman Harker]

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.

 

[Dave Hawley]

Hi Matt

As Norman has shown COUNTIF will do the job. However, a very simple
Pivot table might be easier.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****