Sum of mixed leters and numbers.

[Guest]

Hello I am trying to add sums in a table that contain both numbers and letters, such as


PRPT0
8BAAA
QL1TO

these are listed multiple times. I am searching for a formula that will extract the amount of times each one is used in a cell. I would appreciate any help people are willing to give.

 

[Frank Kabel]

Hi
if you want the count of the entire cell content try
=COUNTIF(A:A,"PRPT0")

or try creating a pivot table for this

-----Original Message-----
Hello I am trying to add sums in a table that contain

both numbers and letters, such as

PRPT0
8BAAA
QL1TO

these are listed multiple times. I am searching for a

formula that will extract the amount of times each one is
used in a cell. I would appreciate any help people are
willing to give.

 

[Guest]

Thanks. This worked great.

Hi
if you want the count of the entire cell content try
=COUNTIF(A:A,"PRPT0")

or try creating a pivot table for this

both numbers and letters, such as
formula that will extract the amount of times each one is
used in a cell. I would appreciate any help people are
willing to give.