Try: =COUNTIF(A1:A10,"RN*")

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cjjoo" <cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com> wrote in
message news:cjjoo.1uvoyd_1125911131.4454@excelforum-nospam.com...
>
> 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
>