Try: =COUNTIF(A1:A10,"RN*")
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" wrote in
message ...
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..
--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=401872