Pls Help!

  • Thread starter Thread starter cjjoo
  • Start date Start date
C

cjjoo

i got a row of inputs with letters and numbers at the end of it ( e.g
RN1, RN2)

now i wan to count the number of returns from RN regardless of the
number behind. So how do i do it?

A1:A10

RN1
RN2
RN4

count_num_ of_returns

tks..
 
i have tried it before but it does not work! sob sob . Any more
suggestions? tks
 
i have tried it before but it does not work! sob sob . Any more
suggestions? tk
 
Based on your given conditions, Max's suggested formula

=COUNTIF(A1:A10,\"RN*\"

should work.

Regards
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Seems Simple But I Cant Get It ! 1
Countif Help 3
count - but exclude counting cells with a formula 4
Multiple logics in one formula 1
Conditional Counting of Duplicated Names 4
Counting numbers with a letter attached in excel 13
Excel Need Countifs Formula Help 0
counting distinct entries with a qualification 7

Back
Top