Counting each time text appears in range???

Hi all, is there a function for counting the instances of text in a range of cells?, if i wanted to put a formula in A1000 that looked at the range(A2:A999) how would i get it to check if text exists if so count 1 if 2 instances of text exist count 2 and so on so if every cell had text in it i would end up with a figure of 997 in A1000.

is this possible?

regards,
Simon

Hi Simon,

Try:
=SUM(IF(ISTEXT(A2:A999),1,0))
as an array formula - entered with <Ctrl-Shift-Enter>, instead of <Enter>.

Cheers

--
macropod
[MVP - Microsoft Word]


"Simon Lloyd" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi all, is there a function for counting the instances of text in a
> range of cells?, if i wanted to put a formula in A1000 that looked at
> the range(A2:A999) how would i get it to check if text exists if so
> count 1 if 2 instances of text exist count 2 and so on so if every cell
> had text in it i would end up with a figure of 997 in A1000.
>
> is this possible?
>
> regards,
> Simon
>
>
> --
> Simon Lloyd
> ------------------------------------------------------------------------
> Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
> View this thread: http://www.excelforum.com/showthread...hreadid=550270
>