Column count if's

  • Thread starter Thread starter Rusty
  • Start date Start date
R

Rusty

I have a column with employee code numbers. ie. A23,A34,A54,B43,B63,C23. They
are always a capital letter ans a 2 digit number. I need to build a formula
for a range that tells me how many employees there are that start with and
"A", a "B", a "C" and so on. Can someone help me with this? Thanks
 
Rusty,
This is what I came up with:
Add a helper column to left of list of employee numbers.
To total emploee numbers with "A"
"=COUNTIF($B$1:$B$3,">A1") in cell to left of
this formula I put "A".
My list of employee numbers is in cell B1 thru B6, I used the numbers you
provided
A23, A34, A54, B34, B63, C23

To total emploee numbers with "B"
"=COUNTIF($B$4:$B$5,">B1") in cell to left of
this formula I put "B".


To total emploee numbers with "C"
"=COUNTIF($B$6:$B$6,">C1") in cell to left of
this formula I put "C".

It should look like this:

A23
A34
A54
B43
B63
C23
"A" 6
"B" 2
"C" 1

hth
 
Hi Rusty
You can use countif with a wildcard e.g:=COUNTIF(A1:A500,"A*")
Adjust range and letter to your needs.
HTH
John
 
Back
Top