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.

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:

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.

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

etc.
--
Gary''s Student - gsnu200839


"Sunnyskies" wrote:

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.

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


"Gary''s Student" wrote:

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

etc.
--
Gary''s Student - gsnu200839


"Sunnyskies" wrote:

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.