Counting each time text appears in range???

[Simon Lloyd]

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

is this possible?

regards,
Simo

 

[macropod]

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]...