Count how many occurrences

[Sunnyskies]

Afternoon from Sunny RSA,

I have a list with two columns A & B:
A B
BFN Rigid 09R08
SBG Rigid 07R04
BFN Rigid 07R01
OIX Rigid 06R04

Now I want a list to show how many rigids per site
Example
BFN = 2
SBG = 1
OIX = 1

No array formulas please.

Thanks in advance.

 

[Stefi]

If you create a list in column C like this

C1: BFN
C2: SBG
etc. then enter in D1 =COUNTIF(A:A,C1&"*")
and fill it down as necessary!


Regards,
Stefi


„Sunnyskies†ezt írta:

 

[Gary''s Student]

=SUMPRODUCT(--(LEFT(A1:A100,3)="BFN"))

etc.

 

[Sunnyskies]

Sorry forgot to explain, there might also be other type of units on the list
and not just rigids ie.

BFN Semi 07S03

I need to count how many unique types, so there will be 09R08 further down
on the list and 07R01 etc.

So I need to count how many Rigids there are even if there are duplicates in
the list.

Thanks