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


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

Counting each time text appears in range???
 

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"
wrote in message
...

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